Pandas Profiling Report

Dataset statistics

Number of variables	46
Number of observations	407684
Missing cells	3871070
Missing cells (%)	20.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	143.1 MiB
Average record size in memory	368.0 B

Variable types

Numeric	11
Categorical	34
Boolean	1

Alerts

`ori` has constant value "CA0371100"	Constant
`agency` has constant value "SD"	Constant
`gendnc_code` has constant value "5.0"	Constant
`id` has a high cardinality: 407684 distinct values	High cardinality
`date` has a high cardinality: 912 distinct values	High cardinality
`time` has a high cardinality: 77771 distinct values	High cardinality
`inters` has a high cardinality: 15939 distinct values	High cardinality
`street` has a high cardinality: 44668 distinct values	High cardinality
`hw_exit` has a high cardinality: 2211 distinct values	High cardinality
`school_name` has a high cardinality: 85 distinct values	High cardinality
`beat_name` has a high cardinality: 127 distinct values	High cardinality
`disability` has a high cardinality: 134 distinct values	High cardinality
`reason_text` has a high cardinality: 1697 distinct values	High cardinality
`reason_detail` has a high cardinality: 282 distinct values	High cardinality
`reason_exp` has a high cardinality: 183583 distinct values	High cardinality
`search_basis` has a high cardinality: 721 distinct values	High cardinality
`search_basis_exp` has a high cardinality: 28990 distinct values	High cardinality
`prop_type` has a high cardinality: 490 distinct values	High cardinality
`cont` has a high cardinality: 669 distinct values	High cardinality
`actions` has a high cardinality: 11672 distinct values	High cardinality
`act_consent` has a high cardinality: 335 distinct values	High cardinality
`df_index` is highly correlated with `Unnamed: 0`	High correlation
`Unnamed: 0` is highly correlated with `df_index`	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`df_index` is highly correlated with `Unnamed: 0`	High correlation
`Unnamed: 0` is highly correlated with `df_index`	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`df_index` is highly correlated with `Unnamed: 0`	High correlation
`Unnamed: 0` is highly correlated with `df_index`	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`is_student` is highly correlated with `is_school`	High correlation
`df_index` is highly correlated with `Unnamed: 0` and 3 other fields	High correlation
`Unnamed: 0` is highly correlated with `df_index` and 3 other fields	High correlation
`stop_id` is highly correlated with `df_index` and 3 other fields	High correlation
`exp_years` is highly correlated with `ldmk` and 1 other fields	High correlation
`dur` is highly correlated with `school_name` and 1 other fields	High correlation
`is_serv` is highly correlated with `ldmk` and 1 other fields	High correlation
`assign_key` is highly correlated with `assign_words` and 2 other fields	High correlation
`assign_words` is highly correlated with `assign_key` and 2 other fields	High correlation
`ldmk` is highly correlated with `df_index` and 15 other fields	High correlation
`is_school` is highly correlated with `is_student`	High correlation
`school_name` is highly correlated with `df_index` and 15 other fields	High correlation
`city` is highly correlated with `ldmk` and 1 other fields	High correlation
`beat` is highly correlated with `ldmk` and 1 other fields	High correlation
`is_student` is highly correlated with `is_school` and 2 other fields	High correlation
`lim_eng` is highly correlated with `ldmk`	High correlation
`age` is highly correlated with `ldmk` and 1 other fields	High correlation
`gender_words` is highly correlated with `ldmk` and 1 other fields	High correlation
`is_gendnc` is highly correlated with `gender_code`	High correlation
`gender_code` is highly correlated with `ldmk` and 2 other fields	High correlation
`lgbt` is highly correlated with `ldmk`	High correlation
`race` is highly correlated with `ldmk` and 1 other fields	High correlation
`reason_words` is highly correlated with `school_name` and 3 other fields	High correlation
`reasonid` is highly correlated with `ldmk` and 2 other fields	High correlation
`seiz_basis` is highly correlated with `dur` and 2 other fields	High correlation
`inters` has 366868 (90.0%) missing values	Missing
`block` has 43330 (10.6%) missing values	Missing
`ldmk` has 407643 (> 99.9%) missing values	Missing
`street` has 16834 (4.1%) missing values	Missing
`hw_exit` has 404618 (99.2%) missing values	Missing
`school_name` has 407362 (99.9%) missing values	Missing
`gendnc_code` has 407507 (> 99.9%) missing values	Missing
`reasonid` has 18844 (4.6%) missing values	Missing
`reason_text` has 18844 (4.6%) missing values	Missing
`reason_detail` has 18838 (4.6%) missing values	Missing
`search_basis` has 321160 (78.8%) missing values	Missing
`search_basis_exp` has 344258 (84.4%) missing values	Missing
`seiz_basis` has 398568 (97.8%) missing values	Missing
`prop_type` has 398568 (97.8%) missing values	Missing
`act_consent` has 297641 (73.0%) missing values	Missing
`block` is highly skewed (γ1 = 254.9436976)	Skewed
`id` is uniformly distributed	Uniform
`ldmk` is uniformly distributed	Uniform
`id` has unique values	Unique

Reproduction

Analysis started	2023-03-29 06:31:19.748200
Analysis finished	2023-03-29 06:33:33.358212
Duration	2 minutes and 13.61 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	187251
Distinct (%)	45.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76802.8756

Minimum	0
Maximum	187250
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	6794.15
Q1	33973
median	67947
Q3	117974
95-th percentile	166865.85
Maximum	187250
Range	187250
Interquartile range (IQR)	84001

Descriptive statistics

Standard deviation	50412.73086
Coefficient of variation (CV)	0.6563911893
Kurtosis	-0.9762821719
Mean	76802.8756
Median Absolute Deviation (MAD)	40395
Skewness	0.354725747
Sum	3.131130354 × 10¹⁰
Variance	2541443433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3	< 0.1%
64668	3	< 0.1%
52378	3	< 0.1%
54425	3	< 0.1%
56472	3	< 0.1%
42135	3	< 0.1%
44182	3	< 0.1%
46229	3	< 0.1%
48276	3	< 0.1%
33939	3	< 0.1%
Other values (187241)	407654	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1	3	< 0.1%
2	3	< 0.1%
3	3	< 0.1%
4	3	< 0.1%
5	3	< 0.1%
6	3	< 0.1%
7	3	< 0.1%
8	3	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
187250	1	< 0.1%
187249	1	< 0.1%
187248	1	< 0.1%
187247	1	< 0.1%
187246	1	< 0.1%
187245	1	< 0.1%
187244	1	< 0.1%
187243	1	< 0.1%
187242	1	< 0.1%
187241	1	< 0.1%

Unnamed: 0
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	187251
Distinct (%)	45.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76803.8756

Minimum	1
Maximum	187251
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	6795.15
Q1	33974
median	67948
Q3	117975
95-th percentile	166866.85
Maximum	187251
Range	187250
Interquartile range (IQR)	84001

Descriptive statistics

Standard deviation	50412.73086
Coefficient of variation (CV)	0.656382643
Kurtosis	-0.9762821719
Mean	76803.8756
Median Absolute Deviation (MAD)	40395
Skewness	0.354725747
Sum	3.131171122 × 10¹⁰
Variance	2541443433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2049	3	< 0.1%
62621	3	< 0.1%
50331	3	< 0.1%
52378	3	< 0.1%
54425	3	< 0.1%
56472	3	< 0.1%
42135	3	< 0.1%
44182	3	< 0.1%
46229	3	< 0.1%
48276	3	< 0.1%
Other values (187241)	407654	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	< 0.1%
2	3	< 0.1%
3	3	< 0.1%
4	3	< 0.1%
5	3	< 0.1%
6	3	< 0.1%
7	3	< 0.1%
8	3	< 0.1%
9	3	< 0.1%
10	3	< 0.1%

Value	Count	Frequency (%)
187251	1	< 0.1%
187250	1	< 0.1%
187249	1	< 0.1%
187248	1	< 0.1%
187247	1	< 0.1%
187246	1	< 0.1%
187245	1	< 0.1%
187244	1	< 0.1%
187243	1	< 0.1%
187242	1	< 0.1%

stop_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	353547
Distinct (%)	86.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	269011.3497

Minimum	84362
Maximum	449933
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	84362
5-th percentile	106360.15
Q1	177796.75
median	269751.5
Q3	359576.25
95-th percentile	431524.85
Maximum	449933
Range	365571
Interquartile range (IQR)	181779.5

Descriptive statistics

Standard deviation	104491.5027
Coefficient of variation (CV)	0.3884278593
Kurtosis	-1.196648741
Mean	269011.3497
Median Absolute Deviation (MAD)	90905
Skewness	-0.006532642956
Sum	1.096716231 × 10¹¹
Variance	1.091847413 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
174011	52	< 0.1%
184085	48	< 0.1%
180326	46	< 0.1%
169932	42	< 0.1%
183655	40	< 0.1%
161095	39	< 0.1%
174472	38	< 0.1%
236965	35	< 0.1%
170316	34	< 0.1%
183646	32	< 0.1%
Other values (353537)	407278	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
84362	1	< 0.1%
84364	1	< 0.1%
84365	1	< 0.1%
84366	1	< 0.1%
84369	1	< 0.1%
84370	1	< 0.1%
84371	1	< 0.1%
84372	2	< 0.1%
84373	1	< 0.1%
84374	1	< 0.1%

Value	Count	Frequency (%)
449933	1	< 0.1%
449726	1	< 0.1%
449716	1	< 0.1%
449709	1	< 0.1%
449701	1	< 0.1%
449694	1	< 0.1%
449693	2	< 0.1%
449692	1	< 0.1%
449687	3	< 0.1%
449675	1	< 0.1%

pid
Real number (ℝ_≥0)

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.26214421

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	52
Range	51
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.224532182
Coefficient of variation (CV)	0.9701998971
Kurtosis	338.2990747
Mean	1.26214421
Median Absolute Deviation (MAD)	0
Skewness	14.70829698
Sum	514556
Variance	1.499479066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	353540	86.7%
2	35536	8.7%
3	9722	2.4%
4	3793	0.9%
5	1715	0.4%
6	889	0.2%
7	531	0.1%
8	360	0.1%
9	257	0.1%
10	210	0.1%
Other values (42)	1131	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	353540	86.7%
2	35536	8.7%
3	9722	2.4%
4	3793	0.9%
5	1715	0.4%
6	889	0.2%
7	531	0.1%
8	360	0.1%
9	257	0.1%
10	210	0.1%

Value	Count	Frequency (%)
52	1	< 0.1%
51	1	< 0.1%
50	1	< 0.1%
49	1	< 0.1%
48	2	< 0.1%
47	2	< 0.1%
46	3	< 0.1%
45	3	< 0.1%
44	3	< 0.1%
43	3	< 0.1%

id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	407684
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

397553_1	1
325762_1	1
194574_1	1
305336_1	1
440720_1	1
Other values (407679)	407679

Length

Max length	9
Median length	8
Mean length	7.965208348
Min length	7

Characters and Unicode

Total characters	3247288
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	407684 ?
Unique (%)	100.0%

Sample

1st row	84362_1
2nd row	84364_1
3rd row	84365_1
4th row	84366_1
5th row	84369_1

Common Values

Value	Count	Frequency (%)
397553_1	1	< 0.1%
325762_1	1	< 0.1%
194574_1	1	< 0.1%
305336_1	1	< 0.1%
440720_1	1	< 0.1%
447632_1	1	< 0.1%
170883_1	1	< 0.1%
132869_1	1	< 0.1%
133994_1	1	< 0.1%
114912_1	1	< 0.1%
Other values (407674)	407674	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
397553_1	1	< 0.1%
374126_1	1	< 0.1%
155359_2	1	< 0.1%
429671_1	1	< 0.1%
114522_1	1	< 0.1%
345194_1	1	< 0.1%
292295_1	1	< 0.1%
245032_2	1	< 0.1%
208957_1	1	< 0.1%
344514_2	1	< 0.1%
Other values (407674)	407674	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
1	674216	20.8%
_	407684	12.6%
2	353904	10.9%
3	332496	10.2%
4	269023	8.3%
9	209563	6.5%
0	205642	6.3%
8	203747	6.3%
6	198566	6.1%
5	196463	6.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2839604	87.4%
Connector Punctuation	407684	12.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	674216	23.7%
2	353904	12.5%
3	332496	11.7%
4	269023	9.5%
9	209563	7.4%
0	205642	7.2%
8	203747	7.2%
6	198566	7.0%
5	196463	6.9%
7	195984	6.9%

Connector Punctuation

Value	Count	Frequency (%)
_	407684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3247288	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	674216	20.8%
_	407684	12.6%
2	353904	10.9%
3	332496	10.2%
4	269023	8.3%
9	209563	6.5%
0	205642	6.3%
8	203747	6.3%
6	198566	6.1%
5	196463	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3247288	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	674216	20.8%
_	407684	12.6%
2	353904	10.9%
3	332496	10.2%
4	269023	8.3%
9	209563	6.5%
0	205642	6.3%
8	203747	6.3%
6	198566	6.1%
5	196463	6.1%

ori
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

CA0371100	407684

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	3669156
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA0371100
2nd row	CA0371100
3rd row	CA0371100
4th row	CA0371100
5th row	CA0371100

Common Values

Value	Count	Frequency (%)
CA0371100	407684	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ca0371100	407684	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	1223052	33.3%
1	815368	22.2%
C	407684	11.1%
A	407684	11.1%
3	407684	11.1%
7	407684	11.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2853788	77.8%
Uppercase Letter	815368	22.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1223052	42.9%
1	815368	28.6%
3	407684	14.3%
7	407684	14.3%

Uppercase Letter

Value	Count	Frequency (%)
C	407684	50.0%
A	407684	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2853788	77.8%
Latin	815368	22.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1223052	42.9%
1	815368	28.6%
3	407684	14.3%
7	407684	14.3%

Latin

Value	Count	Frequency (%)
C	407684	50.0%
A	407684	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3669156	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1223052	33.3%
1	815368	22.2%
C	407684	11.1%
A	407684	11.1%
3	407684	11.1%
7	407684	11.1%

agency
Categorical

CONSTANT
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

SD	407684

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	815368
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SD
2nd row	SD
3rd row	SD
4th row	SD
5th row	SD

Common Values

Value	Count	Frequency (%)
SD	407684	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
sd	407684	100.0%

Most occurring characters

Value	Count	Frequency (%)
S	407684	50.0%
D	407684	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	815368	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	407684	50.0%
D	407684	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	815368	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	407684	50.0%
D	407684	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	815368	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	407684	50.0%
D	407684	50.0%

exp_years
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	40
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.275789582

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	10
95-th percentile	21
Maximum	50
Range	49
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.089598806
Coefficient of variation (CV)	1.129674396
Kurtosis	2.149779906
Mean	6.275789582
Median Absolute Deviation (MAD)	2
Skewness	1.588415896
Sum	2558539
Variance	50.26241123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
1	152249	37.3%
3	33347	8.2%
2	30587	7.5%
5	30179	7.4%
4	24049	5.9%
10	16650	4.1%
11	12187	3.0%
18	11768	2.9%
9	10901	2.7%
12	9835	2.4%
Other values (30)	75932	18.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	152249	37.3%
2	30587	7.5%
3	33347	8.2%
4	24049	5.9%
5	30179	7.4%
6	9370	2.3%
7	4610	1.1%
8	5255	1.3%
9	10901	2.7%
10	16650	4.1%

Value	Count	Frequency (%)
50	4	< 0.1%
49	23	< 0.1%
48	231	0.1%
45	33	< 0.1%
37	2	< 0.1%
35	1	< 0.1%
34	1	< 0.1%
33	35	< 0.1%
32	197	< 0.1%
31	88	< 0.1%

date
Categorical

HIGH CARDINALITY

Distinct	912
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

2020-02-12	799
2019-05-23	793
2020-02-11	791
2019-07-06	755
2020-01-16	749
Other values (907)	403797

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	4076840
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2019-01-01
2nd row	2019-01-01
3rd row	2019-01-01
4th row	2019-01-01
5th row	2019-01-01

Common Values

Value	Count	Frequency (%)
2020-02-12	799	0.2%
2019-05-23	793	0.2%
2020-02-11	791	0.2%
2019-07-06	755	0.2%
2020-01-16	749	0.2%
2019-10-23	734	0.2%
2019-09-24	733	0.2%
2019-08-21	722	0.2%
2019-10-02	715	0.2%
2019-03-27	712	0.2%
Other values (902)	400181	98.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-02-12	799	0.2%
2019-05-23	793	0.2%
2020-02-11	791	0.2%
2019-07-06	755	0.2%
2020-01-16	749	0.2%
2019-10-23	734	0.2%
2019-09-24	733	0.2%
2019-08-21	722	0.2%
2019-10-02	715	0.2%
2019-03-27	712	0.2%
Other values (902)	400181	98.2%

Most occurring characters

Value	Count	Frequency (%)
0	1073720	26.3%
2	865923	21.2%
-	815368	20.0%
1	591994	14.5%
9	254877	6.3%
3	102764	2.5%
5	80571	2.0%
4	79204	1.9%
6	74134	1.8%
7	69263	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3261472	80.0%
Dash Punctuation	815368	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1073720	32.9%
2	865923	26.6%
1	591994	18.2%
9	254877	7.8%
3	102764	3.2%
5	80571	2.5%
4	79204	2.4%
6	74134	2.3%
7	69263	2.1%
8	69022	2.1%

Dash Punctuation

Value	Count	Frequency (%)
-	815368	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	4076840	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1073720	26.3%
2	865923	21.2%
-	815368	20.0%
1	591994	14.5%
9	254877	6.3%
3	102764	2.5%
5	80571	2.0%
4	79204	1.9%
6	74134	1.8%
7	69263	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4076840	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1073720	26.3%
2	865923	21.2%
-	815368	20.0%
1	591994	14.5%
9	254877	6.3%
3	102764	2.5%
5	80571	2.0%
4	79204	1.9%
6	74134	1.8%
7	69263	1.7%

time
Categorical

HIGH CARDINALITY

Distinct	77771
Distinct (%)	19.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

16:00:00	1122
10:00:00	982
15:00:00	976
08:00:00	976
11:00:00	941
Other values (77766)	402687

Length

Max length	19
Median length	8
Mean length	8.002482315
Min length	8

Characters and Unicode

Total characters	3262484
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14534 ?
Unique (%)	3.6%

Sample

1st row	00:15:07
2nd row	00:15:16
3rd row	00:02:00
4th row	00:38:00
5th row	01:06:41

Common Values

Value	Count	Frequency (%)
16:00:00	1122	0.3%
10:00:00	982	0.2%
15:00:00	976	0.2%
08:00:00	976	0.2%
11:00:00	941	0.2%
09:00:00	936	0.2%
22:00:00	914	0.2%
17:00:00	900	0.2%
15:30:00	817	0.2%
07:00:00	800	0.2%
Other values (77761)	398320	97.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
16:00:00	1122	0.3%
10:00:00	982	0.2%
15:00:00	976	0.2%
08:00:00	976	0.2%
11:00:00	941	0.2%
09:00:00	936	0.2%
22:00:00	914	0.2%
17:00:00	900	0.2%
15:30:00	817	0.2%
07:00:00	800	0.2%
Other values (77754)	398412	97.7%

Most occurring characters

Value	Count	Frequency (%)
:	815368	25.0%
0	690766	21.2%
1	418785	12.8%
2	291617	8.9%
5	228173	7.0%
3	221424	6.8%
4	196101	6.0%
8	104305	3.2%
7	100548	3.1%
9	100195	3.1%
Other values (3)	95202	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2446840	75.0%
Other Punctuation	815368	25.0%
Dash Punctuation	184	< 0.1%
Space Separator	92	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	690766	28.2%
1	418785	17.1%
2	291617	11.9%
5	228173	9.3%
3	221424	9.0%
4	196101	8.0%
8	104305	4.3%
7	100548	4.1%
9	100195	4.1%
6	94926	3.9%

Other Punctuation

Value	Count	Frequency (%)
:	815368	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	184	100.0%

Space Separator

Value	Count	Frequency (%)
	92	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	3262484	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	815368	25.0%
0	690766	21.2%
1	418785	12.8%
2	291617	8.9%
5	228173	7.0%
3	221424	6.8%
4	196101	6.0%
8	104305	3.2%
7	100548	3.1%
9	100195	3.1%
Other values (3)	95202	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3262484	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	815368	25.0%
0	690766	21.2%
1	418785	12.8%
2	291617	8.9%
5	228173	7.0%
3	221424	6.8%
4	196101	6.0%
8	104305	3.2%
7	100548	3.1%
9	100195	3.1%
Other values (3)	95202	2.9%

dur
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	337
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.57985597

Minimum	1
Maximum	1440
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	10
median	15
Q3	30
95-th percentile	120
Maximum	1440
Range	1439
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	49.79122848
Coefficient of variation (CV)	1.742179126
Kurtosis	182.3002247
Mean	28.57985597
Median Absolute Deviation (MAD)	6
Skewness	9.249568162
Sum	11651550
Variance	2479.166434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	99603	24.4%
15	49427	12.1%
5	42258	10.4%
20	41432	10.2%
30	28548	7.0%
60	17833	4.4%
8	13319	3.3%
120	12718	3.1%
6	12384	3.0%
7	9335	2.3%
Other values (327)	80827	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1035	0.3%
2	2654	0.7%
3	2755	0.7%
4	2327	0.6%
5	42258	10.4%
6	12384	3.0%
7	9335	2.3%
8	13319	3.3%
9	4340	1.1%
10	99603	24.4%

Value	Count	Frequency (%)
1440	52	< 0.1%
1422	1	< 0.1%
1400	24	< 0.1%
1355	1	< 0.1%
1330	2	< 0.1%
1301	1	< 0.1%
1300	3	< 0.1%
1230	1	< 0.1%
1220	1	< 0.1%
1210	4	< 0.1%

is_serv
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

0	363639
1	44045

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

Most occurring characters

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	363639	89.2%
1	44045	10.8%

assign_key
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.439082721

Minimum	1
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	5
Maximum	10
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.820493846
Coefficient of variation (CV)	1.265037666
Kurtosis	16.05460133
Mean	1.439082721
Median Absolute Deviation (MAD)	0
Skewness	4.194914881
Sum	586691
Variance	3.314197843
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	378571	92.9%
10	13106	3.2%
2	7104	1.7%
9	3700	0.9%
5	1624	0.4%
7	1247	0.3%
6	802	0.2%
4	626	0.2%
8	535	0.1%
3	369	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	378571	92.9%
2	7104	1.7%
3	369	0.1%
4	626	0.2%
5	1624	0.4%
6	802	0.2%
7	1247	0.3%
8	535	0.1%
9	3700	0.9%
10	13106	3.2%

Value	Count	Frequency (%)
10	13106	3.2%
9	3700	0.9%
8	535	0.1%
7	1247	0.3%
6	802	0.2%
5	1624	0.4%
4	626	0.2%
3	369	0.1%
2	7104	1.7%
1	378571	92.9%

assign_words
Categorical

HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Patrol, traffic enforcement, field operations	378571
Other	13106
Gang enforcement	7104
Investigative/detective	3700
Roadblock or DUI sobriety checkpoint	1624
Other values (5)	3579

Length

Max length	78
Median length	45
Mean length	42.77467107
Min length	5

Characters and Unicode

Total characters	17438549
Distinct characters	39
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Patrol, traffic enforcement, field operations
2nd row	Patrol, traffic enforcement, field operations
3rd row	Patrol, traffic enforcement, field operations
4th row	Patrol, traffic enforcement, field operations
5th row	Patrol, traffic enforcement, field operations

Common Values

Value	Count	Frequency (%)
Patrol, traffic enforcement, field operations	378571	92.9%
Other	13106	3.2%
Gang enforcement	7104	1.7%
Investigative/detective	3700	0.9%
Roadblock or DUI sobriety checkpoint	1624	0.4%
Task force	1247	0.3%
Narcotics/vice	802	0.2%
Special events	626	0.2%
K1-12 public school inlcuding school resource officer or school police officer	535	0.1%
Compliance check	369	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
enforcement	385675	19.8%
patrol	378571	19.5%
field	378571	19.5%
operations	378571	19.5%
traffic	378571	19.5%
other	13106	0.7%
gang	7104	0.4%
investigative/detective	3700	0.2%
or	2159	0.1%
roadblock	1624	0.1%
Other values (17)	15508	0.8%

Most occurring characters

Value	Count	Frequency (%)
e	1956361	11.2%
t	1553970	8.9%
r	1542466	8.8%
o	1537811	8.8%
	1535476	8.8%
f	1524775	8.7%
n	1164414	6.7%
i	1155870	6.6%
a	1151185	6.6%
c	783019	4.5%
Other values (29)	3533202	20.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14726733	84.4%
Space Separator	1535476	8.8%
Other Punctuation	761644	4.4%
Uppercase Letter	412556	2.4%
Decimal Number	1605	< 0.1%
Dash Punctuation	535	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1956361	13.3%
t	1553970	10.6%
r	1542466	10.5%
o	1537811	10.4%
f	1524775	10.4%
n	1164414	7.9%
i	1155870	7.8%
a	1151185	7.8%
c	783019	5.3%
l	762971	5.2%
Other values (11)	1593891	10.8%

Uppercase Letter

Value	Count	Frequency (%)
P	378571	91.8%
O	13106	3.2%
G	7104	1.7%
I	5324	1.3%
R	1624	0.4%
D	1624	0.4%
U	1624	0.4%
T	1247	0.3%
N	802	0.2%
S	626	0.2%
Other values (2)	904	0.2%

Other Punctuation

Value	Count	Frequency (%)
,	757142	99.4%
/	4502	0.6%

Decimal Number

Value	Count	Frequency (%)
1	1070	66.7%
2	535	33.3%

Space Separator

Value	Count	Frequency (%)
	1535476	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	535	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	15139289	86.8%
Common	2299260	13.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1956361	12.9%
t	1553970	10.3%
r	1542466	10.2%
o	1537811	10.2%
f	1524775	10.1%
n	1164414	7.7%
i	1155870	7.6%
a	1151185	7.6%
c	783019	5.2%
l	762971	5.0%
Other values (23)	2006447	13.3%

Common

Value	Count	Frequency (%)
	1535476	66.8%
,	757142	32.9%
/	4502	0.2%
1	1070	< 0.1%
-	535	< 0.1%
2	535	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17438549	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1956361	11.2%
t	1553970	8.9%
r	1542466	8.8%
o	1537811	8.8%
	1535476	8.8%
f	1524775	8.7%
n	1164414	6.7%
i	1155870	6.6%
a	1151185	6.6%
c	783019	4.5%
Other values (29)	3533202	20.3%

inters
Categorical

HIGH CARDINALITY
MISSING

Distinct	15939
Distinct (%)	39.1%
Missing	366868
Missing (%)	90.0%
Memory size	3.1 MiB

BROADWAY	278
MIRAMAR WAY	250
CAMINO DE LA PLAZA/ CAMIONES WAY	222
OTAY VALLEY ROAD/ AVENIDA DE LAS VISTAS	145
G Street	137
Other values (15934)	39784

Length

Max length	77
Median length	59
Mean length	13.92017836
Min length	1

Characters and Unicode

Total characters	568166
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11202 ?
Unique (%)	27.4%

Sample

1st row	governor dr
2nd row	la jolla village dr
3rd row	mission/hornblend
4th row	hornblend/mission blvd
5th row	clairemont mesa blvd

Common Values

Value	Count	Frequency (%)
BROADWAY	278	0.1%
MIRAMAR WAY	250	0.1%
CAMINO DE LA PLAZA/ CAMIONES WAY	222	0.1%
OTAY VALLEY ROAD/ AVENIDA DE LAS VISTAS	145	< 0.1%
G Street	137	< 0.1%
imperial	129	< 0.1%
garnet	128	< 0.1%
w ash	127	< 0.1%
MARKET ST	108	< 0.1%
PB/MB	105	< 0.1%
Other values (15929)	39187	9.6%
(Missing)	366868	90.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
and	3985	3.7%
st	3619	3.4%
ave	3372	3.2%
	3273	3.1%
street	2699	2.5%
beach	1622	1.5%
rd	1616	1.5%
mission	1598	1.5%
blvd	1541	1.4%
dr	1353	1.3%
Other values (4709)	81672	76.8%

Most occurring characters

Value	Count	Frequency (%)
	65653	11.6%
a	30420	5.4%
e	28576	5.0%
A	27394	4.8%
r	22026	3.9%
E	20689	3.6%
n	19236	3.4%
t	18707	3.3%
R	17141	3.0%
o	16782	3.0%
Other values (68)	301542	53.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	253618	44.6%
Uppercase Letter	218264	38.4%
Space Separator	65653	11.6%
Decimal Number	19086	3.4%
Other Punctuation	9867	1.7%
Dash Punctuation	1667	0.3%
Open Punctuation	5	< 0.1%
Close Punctuation	5	< 0.1%
Math Symbol	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	30420	12.0%
e	28576	11.3%
r	22026	8.7%
n	19236	7.6%
t	18707	7.4%
o	16782	6.6%
i	16117	6.4%
s	14379	5.7%
l	13637	5.4%
d	13130	5.2%
Other values (16)	60608	23.9%

Uppercase Letter

Value	Count	Frequency (%)
A	27394	12.6%
E	20689	9.5%
R	17141	7.9%
S	15712	7.2%
I	15083	6.9%
N	13468	6.2%
O	12558	5.8%
T	11194	5.1%
L	10226	4.7%
C	9970	4.6%
Other values (16)	64829	29.7%

Other Punctuation

Value	Count	Frequency (%)
/	8725	88.4%
.	577	5.8%
&	194	2.0%
@	181	1.8%
,	116	1.2%
'	59	0.6%
!	5	0.1%
:	5	0.1%
#	3	< 0.1%
;	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
5	5996	31.4%
1	3466	18.2%
8	2088	10.9%
0	1848	9.7%
6	1280	6.7%
4	1200	6.3%
3	1120	5.9%
2	971	5.1%
9	627	3.3%
7	490	2.6%

Space Separator

Value	Count	Frequency (%)
	65653	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1667	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Math Symbol

Value	Count	Frequency (%)
=	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	471882	83.1%
Common	96284	16.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	30420	6.4%
e	28576	6.1%
A	27394	5.8%
r	22026	4.7%
E	20689	4.4%
n	19236	4.1%
t	18707	4.0%
R	17141	3.6%
o	16782	3.6%
i	16117	3.4%
Other values (42)	254794	54.0%

Common

Value	Count	Frequency (%)
	65653	68.2%
/	8725	9.1%
5	5996	6.2%
1	3466	3.6%
8	2088	2.2%
0	1848	1.9%
-	1667	1.7%
6	1280	1.3%
4	1200	1.2%
3	1120	1.2%
Other values (16)	3241	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	568166	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	65653	11.6%
a	30420	5.4%
e	28576	5.0%
A	27394	4.8%
r	22026	3.9%
E	20689	3.6%
n	19236	3.4%
t	18707	3.3%
R	17141	3.0%
o	16782	3.0%
Other values (68)	301542	53.1%

block
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	307
Distinct (%)	0.1%
Missing	43330
Missing (%)	10.6%
Infinite	0
Infinite (%)	0.0%
Mean	7028.818951

Minimum	0
Maximum	99999900
Zeros	133
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	200
Q1	1300
median	3200
Q3	4800
95-th percentile	9600
Maximum	99999900
Range	99999900
Interquartile range (IQR)	3500

Descriptive statistics

Standard deviation	321105.1911
Coefficient of variation (CV)	45.68408909
Kurtosis	77631.69518
Mean	7028.818951
Median Absolute Deviation (MAD)	1800
Skewness	254.9436976
Sum	2560978300
Variance	1.031085438 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11707	2.9%
700	9976	2.4%
3000	8781	2.2%
4000	8565	2.1%
1000	8233	2.0%
500	8060	2.0%
800	7831	1.9%
4200	7434	1.8%
4300	7320	1.8%
3800	7149	1.8%
Other values (297)	279298	68.5%
(Missing)	43330	10.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	133	< 0.1%
100	11707	2.9%
200	7056	1.7%
300	6640	1.6%
400	5851	1.4%
500	8060	2.0%
600	6673	1.6%
700	9976	2.4%
800	7831	1.9%
900	6361	1.6%

Value	Count	Frequency (%)
99999900	3	< 0.1%
18007300	1	< 0.1%
9999900	70	< 0.1%
5600900	1	< 0.1%
999900	221	0.1%
520000	1	< 0.1%
180000	1	< 0.1%
154000	1	< 0.1%
147000	1	< 0.1%
140000	1	< 0.1%

ldmk
Categorical

HIGH CORRELATION
MISSING
UNIFORM

Distinct	36
Distinct (%)	87.8%
Missing	407643
Missing (%)	> 99.9%
Memory size	3.1 MiB

15nb exit	4
i805/43rd St	2
North Cove Park Pacific beach	2
WESTBOUND STATE ROUTE-94/EUCLID AVENUE	1
sr905 / i805	1
Other values (31)	31

Length

Max length	41
Median length	29
Mean length	19.3902439
Min length	8

Characters and Unicode

Total characters	795
Distinct characters	58
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	33 ?
Unique (%)	80.5%

Sample

1st row	sr905 / i805
2nd row	North Cove Park Pacific beach
3rd row	North Cove Park Pacific beach
4th row	I15 / I8
5th row	ON TROLLEY IN SANTEE

Common Values

Value	Count	Frequency (%)
15nb exit	4	< 0.1%
i805/43rd St	2	< 0.1%
North Cove Park Pacific beach	2	< 0.1%
WESTBOUND STATE ROUTE-94/EUCLID AVENUE	1	< 0.1%
sr905 / i805	1	< 0.1%
CANYONSIDE PARK	1	< 0.1%
de anza cove	1	< 0.1%
I-15 SB AT FRIARS	1	< 0.1%
I15 / I8	1	< 0.1%
STATE ROUTE-163/UNIVERSITY AVENUE	1	< 0.1%
Other values (26)	26	< 0.1%
(Missing)	407643	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
at	9	5.9%
	8	5.3%
sb	6	3.9%
park	6	3.9%
and	5	3.3%
i-15	5	3.3%
balboa	5	3.3%
nb	4	2.6%
exit	4	2.6%
15nb	4	2.6%
Other values (66)	96	63.2%

Most occurring characters

Value	Count	Frequency (%)
	111	14.0%
A	42	5.3%
E	40	5.0%
T	32	4.0%
R	30	3.8%
B	29	3.6%
a	29	3.6%
I	27	3.4%
S	26	3.3%
N	25	3.1%
Other values (48)	404	50.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	361	45.4%
Lowercase Letter	218	27.4%
Space Separator	111	14.0%
Decimal Number	80	10.1%
Dash Punctuation	13	1.6%
Other Punctuation	12	1.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	42	11.6%
E	40	11.1%
T	32	8.9%
R	30	8.3%
B	29	8.0%
I	27	7.5%
S	26	7.2%
N	25	6.9%
O	22	6.1%
D	14	3.9%
Other values (12)	74	20.5%

Lowercase Letter

Value	Count	Frequency (%)
a	29	13.3%
e	22	10.1%
n	18	8.3%
t	18	8.3%
r	17	7.8%
o	17	7.8%
i	14	6.4%
b	12	5.5%
c	11	5.0%
d	9	4.1%
Other values (12)	51	23.4%

Decimal Number

Value	Count	Frequency (%)
5	25	31.2%
1	16	20.0%
0	8	10.0%
8	7	8.8%
9	6	7.5%
4	6	7.5%
3	5	6.2%
6	4	5.0%
2	2	2.5%
7	1	1.2%

Other Punctuation

Value	Count	Frequency (%)
/	7	58.3%
@	5	41.7%

Space Separator

Value	Count	Frequency (%)
	111	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	13	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	579	72.8%
Common	216	27.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	42	7.3%
E	40	6.9%
T	32	5.5%
R	30	5.2%
B	29	5.0%
a	29	5.0%
I	27	4.7%
S	26	4.5%
N	25	4.3%
O	22	3.8%
Other values (34)	277	47.8%

Common

Value	Count	Frequency (%)
	111	51.4%
5	25	11.6%
1	16	7.4%
-	13	6.0%
0	8	3.7%
8	7	3.2%
/	7	3.2%
9	6	2.8%
4	6	2.8%
3	5	2.3%
Other values (4)	12	5.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	795	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	111	14.0%
A	42	5.3%
E	40	5.0%
T	32	4.0%
R	30	3.8%
B	29	3.6%
a	29	3.6%
I	27	3.4%
S	26	3.3%
N	25	3.1%
Other values (48)	404	50.8%

street
Categorical

HIGH CARDINALITY
MISSING

Distinct	44668
Distinct (%)	11.4%
Missing	16834
Missing (%)	4.1%
Memory size	3.1 MiB

El Cajon Blvd	2488
el cajon blvd	1577
imperial ave	1551
imperial	1469
garnet	1367
Other values (44663)	382398

Length

Max length	43
Median length	36
Mean length	10.67243955
Min length	1

Characters and Unicode

Total characters	4171323
Distinct characters	82
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24136 ?
Unique (%)	6.2%

Sample

1st row	UNIVERSITY
2nd row	hillside dr
3rd row	ocean blvd
4th row	garnet
5th row	coronado

Common Values

Value	Count	Frequency (%)
El Cajon Blvd	2488	0.6%
el cajon blvd	1577	0.4%
imperial ave	1551	0.4%
imperial	1469	0.4%
garnet	1367	0.3%
university ave	1270	0.3%
University Ave	1240	0.3%
university	1221	0.3%
EL CAJON BLVD	1123	0.3%
commercial	1047	0.3%
Other values (44658)	376497	92.4%
(Missing)	16834	4.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ave	47927	6.1%
st	39901	5.1%
street	37969	4.9%
blvd	26679	3.4%
avenue	17957	2.3%
rd	15152	1.9%
dr	12807	1.6%
mission	11774	1.5%
road	10459	1.3%
el	9610	1.2%
Other values (10930)	549297	70.5%

Most occurring characters

Value	Count	Frequency (%)
	389073	9.3%
e	299210	7.2%
a	257248	6.2%
t	210603	5.0%
r	205794	4.9%
n	163322	3.9%
A	155793	3.7%
o	151343	3.6%
i	143971	3.5%
l	135009	3.2%
Other values (72)	2059957	49.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2348150	56.3%
Uppercase Letter	1323188	31.7%
Space Separator	389073	9.3%
Decimal Number	99771	2.4%
Other Punctuation	9179	0.2%
Dash Punctuation	1695	< 0.1%
Open Punctuation	110	< 0.1%
Close Punctuation	108	< 0.1%
Modifier Symbol	46	< 0.1%
Math Symbol	2	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	299210	12.7%
a	257248	11.0%
t	210603	9.0%
r	205794	8.8%
n	163322	7.0%
o	151343	6.4%
i	143971	6.1%
l	135009	5.7%
s	132042	5.6%
v	100060	4.3%
Other values (16)	549548	23.4%

Uppercase Letter

Value	Count	Frequency (%)
A	155793	11.8%
E	128833	9.7%
R	111686	8.4%
S	109975	8.3%
T	83749	6.3%
N	75814	5.7%
I	72833	5.5%
O	69409	5.2%
L	68521	5.2%
D	62917	4.8%
Other values (16)	383658	29.0%

Other Punctuation

Value	Count	Frequency (%)
.	7202	78.5%
/	1209	13.2%
&	330	3.6%
#	182	2.0%
@	95	1.0%
'	70	0.8%
,	54	0.6%
:	22	0.2%
;	11	0.1%
\	2	< 0.1%
Other values (2)	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	19805	19.9%
5	15134	15.2%
4	14014	14.0%
3	10710	10.7%
0	9419	9.4%
6	9332	9.4%
7	6912	6.9%
2	6662	6.7%
8	4663	4.7%
9	3120	3.1%

Open Punctuation

Value	Count	Frequency (%)
(	108	98.2%
[	2	1.8%

Space Separator

Value	Count	Frequency (%)
	389073	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1695	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	108	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	46	100.0%

Math Symbol

Value	Count	Frequency (%)
=	2	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3671338	88.0%
Common	499985	12.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	299210	8.1%
a	257248	7.0%
t	210603	5.7%
r	205794	5.6%
n	163322	4.4%
A	155793	4.2%
o	151343	4.1%
i	143971	3.9%
l	135009	3.7%
s	132042	3.6%
Other values (42)	1817003	49.5%

Common

Value	Count	Frequency (%)
	389073	77.8%
1	19805	4.0%
5	15134	3.0%
4	14014	2.8%
3	10710	2.1%
0	9419	1.9%
6	9332	1.9%
.	7202	1.4%
7	6912	1.4%
2	6662	1.3%
Other values (20)	11722	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4171323	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	389073	9.3%
e	299210	7.2%
a	257248	6.2%
t	210603	5.0%
r	205794	4.9%
n	163322	3.9%
A	155793	3.7%
o	151343	3.6%
i	143971	3.5%
l	135009	3.2%
Other values (72)	2059957	49.4%

hw_exit
Categorical

HIGH CARDINALITY
MISSING

Distinct	2211
Distinct (%)	72.1%
Missing	404618
Missing (%)	99.2%
Memory size	3.1 MiB

NB I-15	36
I-805/PLAZA BOULEVARD	31
I-805/SR-54	29
SR 905	28
SB I-15	26
Other values (2206)	2916

Length

Max length	60
Median length	44
Mean length	18.40378343
Min length	2

Characters and Unicode

Total characters	56426
Distinct characters	74
Distinct categories	10 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1907 ?
Unique (%)	62.2%

Sample

1st row	n/b 5 @ sea world
2nd row	I15NB @ AERO DR
3rd row	wB 8 @ WARING
4th row	15 AT MIRAMAR
5th row	15 AT 163

Common Values

Value	Count	Frequency (%)
NB I-15	36	< 0.1%
I-805/PLAZA BOULEVARD	31	< 0.1%
I-805/SR-54	29	< 0.1%
SR 905	28	< 0.1%
SB I-15	26	< 0.1%
I-805/43RD STREET	23	< 0.1%
I-805/H STREET	19	< 0.1%
NB 805 AT SR-163	18	< 0.1%
I-805/IMPERIAL AVENUE	14	< 0.1%
NB 805 AT MURRAY RIDGE ROAD	14	< 0.1%
Other values (2201)	2828	0.7%
(Missing)	404618	99.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
at	960	8.2%
15	588	5.0%
sb	515	4.4%
	500	4.3%
nb	440	3.8%
805	300	2.6%
i-15	266	2.3%
street	229	2.0%
and	206	1.8%
road	185	1.6%
Other values (803)	7487	64.1%

Most occurring characters

Value	Count	Frequency (%)
	8622	15.3%
5	2773	4.9%
A	2373	4.2%
E	2281	4.0%
T	2227	3.9%
a	2185	3.9%
R	2070	3.7%
I	1803	3.2%
S	1730	3.1%
N	1479	2.6%
Other values (64)	28883	51.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	21601	38.3%
Lowercase Letter	15708	27.8%
Space Separator	8622	15.3%
Decimal Number	7684	13.6%
Other Punctuation	1495	2.6%
Dash Punctuation	1304	2.3%
Open Punctuation	5	< 0.1%
Close Punctuation	5	< 0.1%
Math Symbol	1	< 0.1%
Connector Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	2373	11.0%
E	2281	10.6%
T	2227	10.3%
R	2070	9.6%
I	1803	8.3%
S	1730	8.0%
N	1479	6.8%
O	1256	5.8%
B	1235	5.7%
D	823	3.8%
Other values (16)	4324	20.0%

Lowercase Letter

Value	Count	Frequency (%)
a	2185	13.9%
r	1442	9.2%
e	1414	9.0%
t	1414	9.0%
n	1144	7.3%
s	1065	6.8%
o	1004	6.4%
b	963	6.1%
i	759	4.8%
l	658	4.2%
Other values (16)	3660	23.3%

Decimal Number

Value	Count	Frequency (%)
5	2773	36.1%
1	1436	18.7%
8	1091	14.2%
0	834	10.9%
6	401	5.2%
4	298	3.9%
3	287	3.7%
9	277	3.6%
2	186	2.4%
7	101	1.3%

Other Punctuation

Value	Count	Frequency (%)
/	1091	73.0%
@	344	23.0%
,	29	1.9%
.	16	1.1%
&	14	0.9%
!	1	0.1%

Space Separator

Value	Count	Frequency (%)
	8622	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1304	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	5	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	5	100.0%

Math Symbol

Value	Count	Frequency (%)
=	1	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37309	66.1%
Common	19117	33.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	2373	6.4%
E	2281	6.1%
T	2227	6.0%
a	2185	5.9%
R	2070	5.5%
I	1803	4.8%
S	1730	4.6%
N	1479	4.0%
r	1442	3.9%
e	1414	3.8%
Other values (42)	18305	49.1%

Common

Value	Count	Frequency (%)
	8622	45.1%
5	2773	14.5%
1	1436	7.5%
-	1304	6.8%
/	1091	5.7%
8	1091	5.7%
0	834	4.4%
6	401	2.1%
@	344	1.8%
4	298	1.6%
Other values (12)	923	4.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56426	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8622	15.3%
5	2773	4.9%
A	2373	4.2%
E	2281	4.0%
T	2227	3.9%
a	2185	3.9%
R	2070	3.7%
I	1803	3.2%
S	1730	3.1%
N	1479	2.6%
Other values (64)	28883	51.2%

is_school
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

0	407362
1	322

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	407362	99.9%
1	322	0.1%

school_name
Categorical

HIGH CARDINALITY
HIGH CORRELATION
MISSING

Distinct	85
Distinct (%)	26.4%
Missing	407362
Missing (%)	99.9%
Memory size	3.1 MiB

Ibarra Elementary (San Diego Unified) 37683380108290	27
Rancho Bernardo High (Poway Unified) 37682963730819	16
Del Norte High (Poway Unified) 37682960118935	15
Serra High (San Diego Unified) 37683383730173	13
Montgomery Senior High (Sweetwater Union High) 37684113738234	13
Other values (80)	238

Length

Max length	69
Median length	66
Mean length	52.7515528
Min length	34

Characters and Unicode

Total characters	16986
Distinct characters	65
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	32 ?
Unique (%)	9.9%

Sample

1st row	Garfield Elementary (San Diego Unified) 37683386039655
2nd row	Garfield Elementary (San Diego Unified) 37683386039655
3rd row	Garfield Elementary (San Diego Unified) 37683386039655
4th row	Garfield Elementary (San Diego Unified) 37683386039655
5th row	Grant K-8 (San Diego Unified) 37683386039671

Common Values

Value	Count	Frequency (%)
Ibarra Elementary (San Diego Unified) 37683380108290	27	< 0.1%
Rancho Bernardo High (Poway Unified) 37682963730819	16	< 0.1%
Del Norte High (Poway Unified) 37682960118935	15	< 0.1%
Serra High (San Diego Unified) 37683383730173	13	< 0.1%
Montgomery Senior High (Sweetwater Union High) 37684113738234	13	< 0.1%
The O'Farrell Charter (San Diego Unified) 37683386061964	13	< 0.1%
De Portola Middle (San Diego Unified) 37683386106181	13	< 0.1%
Torrey Pines High (San Dieguito Union High) 37683463730033	11	< 0.1%
Sunset Elementary (San Ysidro Elementary) 37683796093264	11	< 0.1%
San Ysidro High (Sweetwater Union High) 37684113731502	9	< 0.1%
Other values (75)	181	< 0.1%
(Missing)	407362	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	222	10.8%
unified	221	10.7%
high	165	8.0%
diego	149	7.2%
elementary	144	7.0%
poway	72	3.5%
union	62	3.0%
middle	50	2.4%
ysidro	48	2.3%
sweetwater	31	1.5%
Other values (200)	896	43.5%

Most occurring characters

Value	Count	Frequency (%)
	1738	10.2%
e	1193	7.0%
i	1088	6.4%
3	1054	6.2%
n	915	5.4%
a	813	4.8%
6	688	4.1%
8	636	3.7%
r	616	3.6%
o	589	3.5%
Other values (55)	7656	45.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8285	48.8%
Decimal Number	4515	26.6%
Uppercase Letter	1774	10.4%
Space Separator	1738	10.2%
Close Punctuation	322	1.9%
Open Punctuation	322	1.9%
Other Punctuation	23	0.1%
Dash Punctuation	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1193	14.4%
i	1088	13.1%
n	915	11.0%
a	813	9.8%
r	616	7.4%
o	589	7.1%
d	431	5.2%
t	402	4.9%
g	375	4.5%
l	345	4.2%
Other values (14)	1518	18.3%

Uppercase Letter

Value	Count	Frequency (%)
S	331	18.7%
U	285	16.1%
D	214	12.1%
H	179	10.1%
E	149	8.4%
P	113	6.4%
M	102	5.7%
C	90	5.1%
Y	48	2.7%
B	46	2.6%
Other values (14)	217	12.2%

Decimal Number

Value	Count	Frequency (%)
3	1054	23.3%
6	688	15.2%
8	636	14.1%
7	542	12.0%
0	467	10.3%
1	377	8.3%
9	280	6.2%
2	206	4.6%
4	147	3.3%
5	118	2.6%

Other Punctuation

Value	Count	Frequency (%)
'	13	56.5%
.	9	39.1%
/	1	4.3%

Space Separator

Value	Count	Frequency (%)
	1738	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	322	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	322	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10059	59.2%
Common	6927	40.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1193	11.9%
i	1088	10.8%
n	915	9.1%
a	813	8.1%
r	616	6.1%
o	589	5.9%
d	431	4.3%
t	402	4.0%
g	375	3.7%
l	345	3.4%
Other values (38)	3292	32.7%

Common

Value	Count	Frequency (%)
	1738	25.1%
3	1054	15.2%
6	688	9.9%
8	636	9.2%
7	542	7.8%
0	467	6.7%
1	377	5.4%
)	322	4.6%
(	322	4.6%
9	280	4.0%
Other values (7)	501	7.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16986	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1738	10.2%
e	1193	7.0%
i	1088	6.4%
3	1054	6.2%
n	915	5.4%
a	813	4.8%
6	688	4.1%
8	636	3.7%
r	616	3.6%
o	589	3.5%
Other values (55)	7656	45.1%

city
Categorical

HIGH CORRELATION

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

SAN DIEGO	400853
SAN YSIDRO	2072
CHULA VISTA	1033
NATIONAL CITY	783
EL CAJON	415
Other values (41)	2528

Length

Max length	36
Median length	9
Mean length	9.017876591
Min length	4

Characters and Unicode

Total characters	3676444
Distinct characters	25
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	SAN DIEGO
2nd row	LA JOLLA
3rd row	SAN DIEGO
4th row	SAN DIEGO
5th row	SAN DIEGO

Common Values

Value	Count	Frequency (%)
SAN DIEGO	400853	98.3%
SAN YSIDRO	2072	0.5%
CHULA VISTA	1033	0.3%
NATIONAL CITY	783	0.2%
EL CAJON	415	0.1%
ESCONDIDO	398	0.1%
LA MESA	310	0.1%
LA JOLLA	287	0.1%
LEMON GROVE	282	0.1%
SANTEE	209	0.1%
Other values (36)	1042	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	403140	49.5%
diego	400856	49.2%
ysidro	2072	0.3%
vista	1034	0.1%
chula	1033	0.1%
national	783	0.1%
city	783	0.1%
la	597	0.1%
el	415	0.1%
cajon	415	0.1%
Other values (49)	3319	0.4%

Most occurring characters

Value	Count	Frequency (%)
A	409647	11.1%
S	407720	11.1%
	406763	11.1%
I	406683	11.1%
O	406433	11.1%
N	406432	11.1%
D	403934	11.0%
E	403924	11.0%
G	401346	10.9%
L	4731	0.1%
Other values (15)	18831	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	3269678	88.9%
Space Separator	406763	11.1%
Dash Punctuation	3	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	409647	12.5%
S	407720	12.5%
I	406683	12.4%
O	406433	12.4%
N	406432	12.4%
D	403934	12.4%
E	403924	12.4%
G	401346	12.3%
L	4731	0.1%
Y	3255	0.1%
Other values (13)	15573	0.5%

Space Separator

Value	Count	Frequency (%)
	406763	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3269678	88.9%
Common	406766	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	409647	12.5%
S	407720	12.5%
I	406683	12.4%
O	406433	12.4%
N	406432	12.4%
D	403934	12.4%
E	403924	12.4%
G	401346	12.3%
L	4731	0.1%
Y	3255	0.1%
Other values (13)	15573	0.5%

Common

Value	Count	Frequency (%)
	406763	> 99.9%
-	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3676444	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	409647	11.1%
S	407720	11.1%
	406763	11.1%
I	406683	11.1%
O	406433	11.1%
N	406432	11.1%
D	403934	11.0%
E	403924	11.0%
G	401346	10.9%
L	4731	0.1%
Other values (15)	18831	0.5%

beat
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	126
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	511.4569667

Minimum	111
Maximum	999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	111
5-th percentile	121
Q1	315
median	521
Q3	628
95-th percentile	931
Maximum	999
Range	888
Interquartile range (IQR)	313

Descriptive statistics

Standard deviation	242.5767683
Coefficient of variation (CV)	0.4742857837
Kurtosis	-0.7738950676
Mean	511.4569667
Median Absolute Deviation (MAD)	194
Skewness	-0.07003374112
Sum	208512822
Variance	58843.48851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
521	29982	7.4%
122	24592	6.0%
611	16419	4.0%
614	10569	2.6%
524	10192	2.5%
712	9851	2.4%
512	9651	2.4%
813	9582	2.4%
999	9483	2.3%
121	8744	2.1%
Other values (116)	268619	65.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
111	4467	1.1%
112	1542	0.4%
113	1514	0.4%
114	3534	0.9%
115	4463	1.1%
116	3624	0.9%
121	8744	2.1%
122	24592	6.0%
123	4779	1.2%
124	4479	1.1%

Value	Count	Frequency (%)
999	9483	2.3%
937	1047	0.3%
936	393	0.1%
935	691	0.2%
934	5119	1.3%
933	1784	0.4%
932	481	0.1%
931	4407	1.1%
841	715	0.2%
839	1133	0.3%

beat_name
Categorical

HIGH CARDINALITY

Distinct	127
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

East Village 521	29982
Pacific Beach 122	24592
Midway District 611	16419
Ocean Beach 614	10569
Core-Columbia 524	10192
Other values (122)	315930

Length

Max length	25
Median length	22
Mean length	15.90947646
Min length	10

Characters and Unicode

Total characters	6486039
Distinct characters	64
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cherokee Point 839
2nd row	La Jolla 124
3rd row	Pacific Beach 122
4th row	Pacific Beach 122
5th row	Ocean Beach 614

Common Values

Value	Count	Frequency (%)
East Village 521	29982	7.4%
Pacific Beach 122	24592	6.0%
Midway District 611	16419	4.0%
Ocean Beach 614	10569	2.6%
Core-Columbia 524	10192	2.5%
San Ysidro 712	9851	2.4%
Logan Heights 512	9651	2.4%
North Park 813	9582	2.4%
Unknown 999	9411	2.3%
Mission Beach 121	8744	2.1%
Other values (117)	268691	65.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
east	48357	4.1%
beach	43905	3.7%
park	41321	3.5%
mesa	35028	3.0%
village	32954	2.8%
521	29982	2.5%
mission	26001	2.2%
pacific	24592	2.1%
122	24592	2.1%
heights	21711	1.8%
Other values (263)	851684	72.2%

Most occurring characters

Value	Count	Frequency (%)
	772443	11.9%
a	565930	8.7%
e	377516	5.8%
i	375627	5.8%
1	309397	4.8%
l	292727	4.5%
r	273757	4.2%
2	272499	4.2%
s	268438	4.1%
t	259143	4.0%
Other values (54)	2718562	41.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3682859	56.8%
Decimal Number	1223052	18.9%
Uppercase Letter	789444	12.2%
Space Separator	772443	11.9%
Dash Punctuation	10192	0.2%
Other Punctuation	8049	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	565930	15.4%
e	377516	10.3%
i	375627	10.2%
l	292727	7.9%
r	273757	7.4%
s	268438	7.3%
t	259143	7.0%
o	251522	6.8%
n	233816	6.3%
c	157915	4.3%
Other values (16)	626468	17.0%

Uppercase Letter

Value	Count	Frequency (%)
M	109569	13.9%
P	80851	10.2%
B	75772	9.6%
C	72612	9.2%
V	69291	8.8%
E	55874	7.1%
H	46169	5.8%
S	41954	5.3%
L	40574	5.1%
O	27049	3.4%
Other values (14)	169729	21.5%

Decimal Number

Value	Count	Frequency (%)
1	309397	25.3%
2	272499	22.3%
3	153382	12.5%
4	127141	10.4%
5	123115	10.1%
6	83727	6.8%
8	58189	4.8%
7	49152	4.0%
9	46450	3.8%

Other Punctuation

Value	Count	Frequency (%)
/	5351	66.5%
.	1816	22.6%
'	882	11.0%

Space Separator

Value	Count	Frequency (%)
	772443	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10192	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4472303	69.0%
Common	2013736	31.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	565930	12.7%
e	377516	8.4%
i	375627	8.4%
l	292727	6.5%
r	273757	6.1%
s	268438	6.0%
t	259143	5.8%
o	251522	5.6%
n	233816	5.2%
c	157915	3.5%
Other values (40)	1415912	31.7%

Common

Value	Count	Frequency (%)
	772443	38.4%
1	309397	15.4%
2	272499	13.5%
3	153382	7.6%
4	127141	6.3%
5	123115	6.1%
6	83727	4.2%
8	58189	2.9%
7	49152	2.4%
9	46450	2.3%
Other values (4)	18241	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6486039	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	772443	11.9%
a	565930	8.7%
e	377516	5.8%
i	375627	5.8%
1	309397	4.8%
l	292727	4.5%
r	273757	4.2%
2	272499	4.2%
s	268438	4.1%
t	259143	4.0%
Other values (54)	2718562	41.9%

is_student
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

0	407522
1	162

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	407522	> 99.9%
1	162	< 0.1%

lim_eng
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

0	399890
1	7794

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

Most occurring characters

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	399890	98.1%
1	7794	1.9%

age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	102
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.3154919

Minimum	1
Maximum	120
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	1
5-th percentile	20
Q1	26
median	35
Q3	46
95-th percentile	60
Maximum	120
Range	119
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	13.43056039
Coefficient of variation (CV)	0.359919157
Kurtosis	-0.2227158246
Mean	37.3154919
Median Absolute Deviation (MAD)	10
Skewness	0.5885595043
Sum	15212929
Variance	180.3799524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	58428	14.3%
40	42673	10.5%
25	40305	9.9%
50	35877	8.8%
35	33339	8.2%
45	24881	6.1%
60	20837	5.1%
20	20273	5.0%
55	16130	4.0%
21	6938	1.7%
Other values (92)	108003	26.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12	< 0.1%
2	5	< 0.1%
3	3	< 0.1%
4	13	< 0.1%
5	38	< 0.1%
6	13	< 0.1%
7	37	< 0.1%
8	71	< 0.1%
9	43	< 0.1%
10	320	0.1%

Value	Count	Frequency (%)
120	3	< 0.1%
116	1	< 0.1%
100	15	< 0.1%
99	18	< 0.1%
98	3	< 0.1%
97	4	< 0.1%
96	1	< 0.1%
95	20	< 0.1%
94	6	< 0.1%
93	7	< 0.1%

gender_words
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	90
Missing (%)	< 0.1%
Memory size	3.1 MiB

Male	297732
Female	108822
Transgender man/boy	548
Transgender woman/girl	492

Length

Max length	22
Median length	4
Mean length	4.575867162
Min length	4

Characters and Unicode

Total characters	1865096
Distinct characters	19
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Male
2nd row	Female
3rd row	Female
4th row	Male
5th row	Male

Common Values

Value	Count	Frequency (%)
Male	297732	73.0%
Female	108822	26.7%
Transgender man/boy	548	0.1%
Transgender woman/girl	492	0.1%
(Missing)	90	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
male	297732	72.9%
female	108822	26.6%
transgender	1040	0.3%
man/boy	548	0.1%
woman/girl	492	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	517456	27.7%
a	408634	21.9%
l	407046	21.8%
M	297732	16.0%
m	109862	5.9%
F	108822	5.8%
n	3120	0.2%
r	2572	0.1%
g	1532	0.1%
	1040	0.1%
Other values (9)	7280	0.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1455422	78.0%
Uppercase Letter	407594	21.9%
Space Separator	1040	0.1%
Other Punctuation	1040	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	517456	35.6%
a	408634	28.1%
l	407046	28.0%
m	109862	7.5%
n	3120	0.2%
r	2572	0.2%
g	1532	0.1%
o	1040	0.1%
s	1040	0.1%
d	1040	0.1%
Other values (4)	2080	0.1%

Uppercase Letter

Value	Count	Frequency (%)
M	297732	73.0%
F	108822	26.7%
T	1040	0.3%

Space Separator

Value	Count	Frequency (%)
	1040	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	1040	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1863016	99.9%
Common	2080	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	517456	27.8%
a	408634	21.9%
l	407046	21.8%
M	297732	16.0%
m	109862	5.9%
F	108822	5.8%
n	3120	0.2%
r	2572	0.1%
g	1532	0.1%
o	1040	0.1%
Other values (7)	5200	0.3%

Common

Value	Count	Frequency (%)
	1040	50.0%
/	1040	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1865096	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	517456	27.7%
a	408634	21.9%
l	407046	21.8%
M	297732	16.0%
m	109862	5.9%
F	108822	5.8%
n	3120	0.2%
r	2572	0.1%
g	1532	0.1%
	1040	0.1%
Other values (9)	7280	0.4%

is_gendnc
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

0	407507
1	177

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	407507	> 99.9%
1	177	< 0.1%

gender_code
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

1	297732
2	108822
3	548
4	492
0	90

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	407684
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	2
3rd row	2
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	407684	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	407684	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	407684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	297732	73.0%
2	108822	26.7%
3	548	0.1%
4	492	0.1%
0	90	< 0.1%

gendnc_code
Categorical

CONSTANT
MISSING
REJECTED

Distinct	1
Distinct (%)	0.6%
Missing	407507
Missing (%)	> 99.9%
Memory size	3.1 MiB

5.0	177

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	531
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	177	< 0.1%
(Missing)	407507	> 99.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
5.0	177	100.0%

Most occurring characters

Value	Count	Frequency (%)
5	177	33.3%
.	177	33.3%
0	177	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	354	66.7%
Other Punctuation	177	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
5	177	50.0%
0	177	50.0%

Other Punctuation

Value	Count	Frequency (%)
.	177	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	531	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
5	177	33.3%
.	177	33.3%
0	177	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	531	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	177	33.3%
.	177	33.3%
0	177	33.3%

lgbt
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	398.3 KiB

False	396960
True	10724

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	396960	97.4%
True	10724	2.6%

race
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

white	170777
hisp	119669
black	82052
asian	31260
nhopi	3112

Length

Max length	5
Median length	5
Mean length	4.704469638
Min length	4

Characters and Unicode

Total characters	1917937
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	hisp
2nd row	white
3rd row	white
4th row	hisp
5th row	black

Common Values

Value	Count	Frequency (%)
white	170777	41.9%
hisp	119669	29.4%
black	82052	20.1%
asian	31260	7.7%
nhopi	3112	0.8%
aian	814	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
white	170777	41.9%
hisp	119669	29.4%
black	82052	20.1%
asian	31260	7.7%
nhopi	3112	0.8%
aian	814	0.2%

Most occurring characters

Value	Count	Frequency (%)
i	325632	17.0%
h	293558	15.3%
w	170777	8.9%
t	170777	8.9%
e	170777	8.9%
s	150929	7.9%
a	146200	7.6%
p	122781	6.4%
b	82052	4.3%
l	82052	4.3%
Other values (4)	202402	10.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1917937	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	325632	17.0%
h	293558	15.3%
w	170777	8.9%
t	170777	8.9%
e	170777	8.9%
s	150929	7.9%
a	146200	7.6%
p	122781	6.4%
b	82052	4.3%
l	82052	4.3%
Other values (4)	202402	10.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1917937	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	325632	17.0%
h	293558	15.3%
w	170777	8.9%
t	170777	8.9%
e	170777	8.9%
s	150929	7.9%
a	146200	7.6%
p	122781	6.4%
b	82052	4.3%
l	82052	4.3%
Other values (4)	202402	10.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1917937	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	325632	17.0%
h	293558	15.3%
w	170777	8.9%
t	170777	8.9%
e	170777	8.9%
s	150929	7.9%
a	146200	7.6%
p	122781	6.4%
b	82052	4.3%
l	82052	4.3%
Other values (4)	202402	10.6%

disability
Categorical

HIGH CARDINALITY

Distinct	134
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

None	388791
Mental health condition	13848
Other disability	1776
Intellectual or developmental disability, including dementia	626
Speech impairment or limited use of language	558
Other values (129)	2085

Length

Max length	201
Median length	4
Mean length	5.12283288
Min length	4

Characters and Unicode

Total characters	2088497
Distinct characters	30
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	65 ?
Unique (%)	< 0.1%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	388791	95.4%
Mental health condition	13848	3.4%
Other disability	1776	0.4%
Intellectual or developmental disability, including dementia	626	0.2%
Speech impairment or limited use of language	558	0.1%
Deafness or difficulty hearing	461	0.1%
Intellectual or developmental disability, including dementia\|Mental health condition	285	0.1%
Blind or limited vision	268	0.1%
Mental health condition\|Intellectual or developmental disability, including dementia	241	0.1%
Mental health condition\|Other disability	124	< 0.1%
Other values (124)	706	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	388791	85.4%
health	14978	3.3%
condition	14399	3.2%
mental	14372	3.2%
disability	3359	0.7%
or	3355	0.7%
other	1954	0.4%
developmental	1387	0.3%
including	1387	0.3%
limited	1275	0.3%
Other values (50)	10082	2.2%

Most occurring characters

Value	Count	Frequency (%)
n	444578	21.3%
e	438417	21.0%
o	424782	20.3%
N	388791	18.6%
t	59149	2.8%
i	52496	2.5%
	47655	2.3%
l	45125	2.2%
a	41741	2.0%
h	33735	1.6%
Other values (20)	112028	5.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1628493	78.0%
Uppercase Letter	409323	19.6%
Space Separator	47655	2.3%
Math Symbol	1639	0.1%
Other Punctuation	1387	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	444578	27.3%
e	438417	26.9%
o	424782	26.1%
t	59149	3.6%
i	52496	3.2%
l	45125	2.8%
a	41741	2.6%
h	33735	2.1%
d	25090	1.5%
c	19323	1.2%
Other values (10)	44057	2.7%

Uppercase Letter

Value	Count	Frequency (%)
N	388791	95.0%
M	14978	3.7%
O	2199	0.5%
I	1387	0.3%
S	878	0.2%
D	693	0.2%
B	397	0.1%

Space Separator

Value	Count	Frequency (%)
	47655	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	1639	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	1387	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2037816	97.6%
Common	50681	2.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	444578	21.8%
e	438417	21.5%
o	424782	20.8%
N	388791	19.1%
t	59149	2.9%
i	52496	2.6%
l	45125	2.2%
a	41741	2.0%
h	33735	1.7%
d	25090	1.2%
Other values (17)	83912	4.1%

Common

Value	Count	Frequency (%)
	47655	94.0%
\|	1639	3.2%
,	1387	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2088497	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	444578	21.3%
e	438417	21.0%
o	424782	20.3%
N	388791	18.6%
t	59149	2.8%
i	52496	2.5%
	47655	2.3%
l	45125	2.2%
a	41741	2.0%
h	33735	1.6%
Other values (20)	112028	5.4%

reason_words
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	3.1 MiB

Reasonable Suspicion	213781
Traffic Violation	175061
Investigation to determine whether the person was truant	5358
Known to be on Parole / Probation / PRCS / Mandatory Supervision	5126
Consensual Encounter resulting in a search	4418
Other values (3)	3935

Length

Max length	113
Median length	20
Mean length	20.29560757
Min length	17

Characters and Unicode

Total characters	8274093
Distinct characters	43
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Traffic Violation
2nd row	Reasonable Suspicion
3rd row	Reasonable Suspicion
4th row	Reasonable Suspicion
5th row	Reasonable Suspicion

Common Values

Value	Count	Frequency (%)
Reasonable Suspicion	213781	52.4%
Traffic Violation	175061	42.9%
Investigation to determine whether the person was truant	5358	1.3%
Known to be on Parole / Probation / PRCS / Mandatory Supervision	5126	1.3%
Consensual Encounter resulting in a search	4418	1.1%
Knowledge of outstanding arrest warrant/wanted person	3904	1.0%
Determine whether the student violated school policy	27	< 0.1%
Possible conduct warranting discipline under Education Code sections 48900, 48900.2, 48900.3, 48900.4 and 48900.7	4	< 0.1%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
reasonable	213781	22.9%
suspicion	213781	22.9%
traffic	175061	18.8%
violation	175061	18.8%
	15378	1.6%
to	10484	1.1%
person	9262	1.0%
determine	5385	0.6%
whether	5385	0.6%
the	5385	0.6%
Other values (40)	103274	11.1%

Most occurring characters

Value	Count	Frequency (%)
i	997046	12.1%
o	859346	10.4%
a	847079	10.2%
n	710187	8.6%
	524558	6.3%
e	523232	6.3%
s	478220	5.8%
l	406797	4.9%
c	397752	4.8%
f	354026	4.3%
Other values (33)	2175850	26.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6888154	83.2%
Uppercase Letter	841955	10.2%
Space Separator	524558	6.3%
Other Punctuation	19310	0.2%
Decimal Number	116	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	997046	14.5%
o	859346	12.5%
a	847079	12.3%
n	710187	10.3%
e	523232	7.6%
s	478220	6.9%
l	406797	5.9%
c	397752	5.8%
f	354026	5.1%
t	261837	3.8%
Other values (11)	1052632	15.3%

Uppercase Letter

Value	Count	Frequency (%)
S	224033	26.6%
R	218907	26.0%
V	175061	20.8%
T	175061	20.8%
P	15382	1.8%
C	9548	1.1%
K	9030	1.1%
I	5358	0.6%
M	5126	0.6%
E	4422	0.5%

Decimal Number

Value	Count	Frequency (%)
0	40	34.5%
4	24	20.7%
8	20	17.2%
9	20	17.2%
2	4	3.4%
3	4	3.4%
7	4	3.4%

Other Punctuation

Value	Count	Frequency (%)
/	19282	99.9%
.	16	0.1%
,	12	0.1%

Space Separator

Value	Count	Frequency (%)
	524558	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7730109	93.4%
Common	543984	6.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	997046	12.9%
o	859346	11.1%
a	847079	11.0%
n	710187	9.2%
e	523232	6.8%
s	478220	6.2%
l	406797	5.3%
c	397752	5.1%
f	354026	4.6%
t	261837	3.4%
Other values (22)	1894587	24.5%

Common

Value	Count	Frequency (%)
	524558	96.4%
/	19282	3.5%
0	40	< 0.1%
4	24	< 0.1%
8	20	< 0.1%
9	20	< 0.1%
.	16	< 0.1%
,	12	< 0.1%
2	4	< 0.1%
3	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8274093	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	997046	12.1%
o	859346	10.4%
a	847079	10.2%
n	710187	8.6%
	524558	6.3%
e	523232	6.3%
s	478220	5.8%
l	406797	4.9%
c	397752	4.8%
f	354026	4.3%
Other values (33)	2175850	26.3%

reasonid
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	1693
Distinct (%)	0.4%
Missing	18844
Missing (%)	4.6%
Infinite	0
Infinite (%)	0.0%
Mean	51661.96158

Minimum	3
Maximum	99999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	3
5-th percentile	22004
Q1	41063
median	54153
Q3	54655
95-th percentile	99990
Maximum	99999
Range	99996
Interquartile range (IQR)	13592

Descriptive statistics

Standard deviation	17956.08335
Coefficient of variation (CV)	0.3475687488
Kurtosis	1.502584076
Mean	51661.96158
Median Absolute Deviation (MAD)	2017
Skewness	0.4606850036
Sum	2.008823714 × 10¹⁰
Variance	322420929.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
65002	28446	7.0%
32022	18215	4.5%
99990	17159	4.2%
32111	16823	4.1%
54167	16209	4.0%
65000	14655	3.6%
54106	14147	3.5%
54655	11917	2.9%
41063	9946	2.4%
54146	9512	2.3%
Other values (1683)	231811	56.9%
(Missing)	18844	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3	27	< 0.1%
3065	1	< 0.1%
3068	1	< 0.1%
4021	6	< 0.1%
4022	67	< 0.1%
4023	1	< 0.1%
4026	1	< 0.1%
4028	1	< 0.1%
4031	5	< 0.1%
4032	4	< 0.1%

Value	Count	Frequency (%)
99999	5911	1.4%
99990	17159	4.2%
89105	4	< 0.1%
89005	9	< 0.1%
66218	3	< 0.1%
66211	82	< 0.1%
66210	204	0.1%
66208	1646	0.4%
66207	169	< 0.1%
66206	6	< 0.1%

reason_text
Categorical

HIGH CARDINALITY
MISSING

Distinct	1697
Distinct (%)	0.4%
Missing	18844
Missing (%)	4.6%
Memory size	3.1 MiB

65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	28446
602 PC - TRESPASSING (M) 32022	18215
647(E) PC - DIS CON:LODGE W/O CONSENT (M) 32111	16823
22450(A) VC - FAIL STOP VEH:XWALK/ETC (I) 54167	16209
65000 ZZ - LOCAL ORDINANCE VIOL (M) 65000	14655
Other values (1692)	294492

Length

Max length	56
Median length	53
Mean length	44.11001183
Min length	24

Characters and Unicode

Total characters	17151737
Distinct characters	49
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	445 ?
Unique (%)	0.1%

Sample

1st row	27150(A) VC - INADEQUATE MUFFLERS (I) 54116
2nd row	415(2) PC - LOUD/UNREASONABLE NOISE (I) 53130
3rd row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
4th row	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005
5th row	602 PC - TRESPASSING (M) 32022

Common Values

Value	Count	Frequency (%)
65002 ZZ - LOCAL ORDINANCE VIOL (I) 65002	28446	7.0%
602 PC - TRESPASSING (M) 32022	18215	4.5%
647(E) PC - DIS CON:LODGE W/O CONSENT (M) 32111	16823	4.1%
22450(A) VC - FAIL STOP VEH:XWALK/ETC (I) 54167	16209	4.0%
65000 ZZ - LOCAL ORDINANCE VIOL (M) 65000	14655	3.6%
NA - XX ZZ - COMMUNITY CARETAKING (X) 99990	14557	3.6%
22350 VC - UNSAFE SPEED:PREVAIL COND (I) 54106	14147	3.5%
25620 BP - POSS OPEN ALCOHOL:PUBLIC (I) 41063	9946	2.4%
23123.5 VC - NO HND HLD DEVICE W/DRIVE (I) 54655	9532	2.3%
21461(A) VC - DRIVER FAIL OBEY SIGN/ETC (I) 54146	9512	2.3%
Other values (1687)	236798	58.1%
(Missing)	18844	4.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	412682	12.9%
i	218922	6.8%
vc	183432	5.7%
m	124213	3.9%
pc	111743	3.5%
zz	62689	2.0%
65002	56892	1.8%
fail	51302	1.6%
viol	51009	1.6%
local	43101	1.3%
Other values (5845)	1894179	59.0%

Most occurring characters

Value	Count	Frequency (%)
	2821324	16.4%
I	819904	4.8%
E	777645	4.5%
C	738813	4.3%
A	689810	4.0%
(	631649	3.7%
)	631602	3.7%
O	612034	3.6%
0	601951	3.5%
2	564425	3.3%
Other values (39)	8262580	48.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8716397	50.8%
Decimal Number	3603590	21.0%
Space Separator	2821324	16.4%
Open Punctuation	631649	3.7%
Close Punctuation	631602	3.7%
Dash Punctuation	413250	2.4%
Other Punctuation	332906	1.9%
Currency Symbol	829	< 0.1%
Math Symbol	190	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	819904	9.4%
E	777645	8.9%
C	738813	8.5%
A	689810	7.9%
O	612034	7.0%
N	548839	6.3%
L	545179	6.3%
T	438047	5.0%
S	427035	4.9%
P	415949	4.8%
Other values (16)	2703142	31.0%

Decimal Number

Value	Count	Frequency (%)
0	601951	16.7%
2	564425	15.7%
5	561441	15.6%
4	463016	12.8%
1	439987	12.2%
6	334787	9.3%
3	279634	7.8%
9	172665	4.8%
7	118941	3.3%
8	66743	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	169870	51.0%
:	132445	39.8%
.	27167	8.2%
&	3285	1.0%
'	95	< 0.1%
"	42	< 0.1%
,	2	< 0.1%

Space Separator

Value	Count	Frequency (%)
	2821324	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	631649	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	631602	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	413250	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	829	100.0%

Math Symbol

Value	Count	Frequency (%)
+	190	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8716397	50.8%
Common	8435340	49.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	819904	9.4%
E	777645	8.9%
C	738813	8.5%
A	689810	7.9%
O	612034	7.0%
N	548839	6.3%
L	545179	6.3%
T	438047	5.0%
S	427035	4.9%
P	415949	4.8%
Other values (16)	2703142	31.0%

Common

Value	Count	Frequency (%)
	2821324	33.4%
(	631649	7.5%
)	631602	7.5%
0	601951	7.1%
2	564425	6.7%
5	561441	6.7%
4	463016	5.5%
1	439987	5.2%
-	413250	4.9%
6	334787	4.0%
Other values (13)	971908	11.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17151737	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	2821324	16.4%
I	819904	4.8%
E	777645	4.5%
C	738813	4.3%
A	689810	4.0%
(	631649	3.7%
)	631602	3.7%
O	612034	3.6%
0	601951	3.5%
2	564425	3.3%
Other values (39)	8262580	48.2%

reason_detail
Categorical

HIGH CARDINALITY
MISSING

Distinct	282
Distinct (%)	0.1%
Missing	18838
Missing (%)	4.6%
Memory size	3.1 MiB

Moving Violation	107984
Officer witnessed commission of a crime	85183
Matched suspect description	68932
Equipment Violation	51210
Other Reasonable Suspicion of a crime	36636
Other values (277)	38901

Length

Max length	232
Median length	210
Mean length	29.89846623
Min length	16

Characters and Unicode

Total characters	11625899
Distinct characters	46
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	131 ?
Unique (%)	< 0.1%

Sample

1st row	Equipment Violation
2nd row	Officer witnessed commission of a crime
3rd row	Officer witnessed commission of a crime
4th row	Officer witnessed commission of a crime
5th row	Matched suspect description

Common Values

Value	Count	Frequency (%)
Moving Violation	107984	26.5%
Officer witnessed commission of a crime	85183	20.9%
Matched suspect description	68932	16.9%
Equipment Violation	51210	12.6%
Other Reasonable Suspicion of a crime	36636	9.0%
Non-moving Violation, including Registration Violation	15867	3.9%
Witness or Victim identification of Suspect at the scene	8664	2.1%
Matched suspect description\|Witness or Victim identification of Suspect at the scene	2714	0.7%
Matched suspect description\|Officer witnessed commission of a crime	2175	0.5%
Witness or Victim identification of Suspect at the scene\|Matched suspect description	1522	0.4%
Other values (272)	7959	2.0%
(Missing)	18838	4.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
violation	190928	12.3%
of	146809	9.5%
a	130440	8.4%
crime	126477	8.2%
moving	107984	7.0%
suspect	93364	6.0%
witnessed	89822	5.8%
commission	89822	5.8%
officer	86627	5.6%
matched	75197	4.9%
Other values (85)	412092	26.6%

Most occurring characters

Value	Count	Frequency (%)
i	1468469	12.6%
	1160716	10.0%
o	1060373	9.1%
e	913193	7.9%
n	838158	7.2%
s	755743	6.5%
t	753249	6.5%
c	671800	5.8%
a	532953	4.6%
m	392075	3.4%
Other values (36)	3079170	26.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9702646	83.5%
Space Separator	1160716	10.0%
Uppercase Letter	717984	6.2%
Other Punctuation	15873	0.1%
Dash Punctuation	15871	0.1%
Math Symbol	12785	0.1%
Decimal Number	24	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	1468469	15.1%
o	1060373	10.9%
e	913193	9.4%
n	838158	8.6%
s	755743	7.8%
t	753249	7.8%
c	671800	6.9%
a	532953	5.5%
m	392075	4.0%
r	373189	3.8%
Other values (15)	1943444	20.0%

Uppercase Letter

Value	Count	Frequency (%)
V	205240	28.6%
M	187036	26.1%
O	129951	18.1%
R	55291	7.7%
S	54783	7.6%
E	51210	7.1%
N	15867	2.2%
W	14312	2.0%
A	3251	0.5%
C	705	0.1%

Decimal Number

Value	Count	Frequency (%)
0	8	33.3%
4	6	25.0%
8	4	16.7%
9	4	16.7%
7	2	8.3%

Other Punctuation

Value	Count	Frequency (%)
,	15869	> 99.9%
.	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1160716	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	15871	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	12785	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10420630	89.6%
Common	1205269	10.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	1468469	14.1%
o	1060373	10.2%
e	913193	8.8%
n	838158	8.0%
s	755743	7.3%
t	753249	7.2%
c	671800	6.4%
a	532953	5.1%
m	392075	3.8%
r	373189	3.6%
Other values (26)	2661428	25.5%

Common

Value	Count	Frequency (%)
	1160716	96.3%
-	15871	1.3%
,	15869	1.3%
\|	12785	1.1%
0	8	< 0.1%
4	6	< 0.1%
8	4	< 0.1%
9	4	< 0.1%
.	4	< 0.1%
7	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11625899	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	1468469	12.6%
	1160716	10.0%
o	1060373	9.1%
e	913193	7.9%
n	838158	7.2%
s	755743	6.5%
t	753249	6.5%
c	671800	5.8%
a	532953	4.6%
m	392075	3.4%
Other values (36)	3079170	26.5%

reason_exp
Categorical

HIGH CARDINALITY

Distinct	183583
Distinct (%)	45.0%
Missing	82
Missing (%)	< 0.1%
Memory size	3.1 MiB

cell phone	4819
stop sign	4721
speeding	4497
SPEED	4155
encroachment	3658
Other values (183578)	385752

Length

Max length	250
Median length	235
Mean length	28.53012988
Min length	2

Characters and Unicode

Total characters	11628938
Distinct characters	92
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	155880 ?
Unique (%)	38.2%

Sample

1st row	LOUD EXHAUST
2nd row	loud party
3rd row	stumbling back and forth, unable to maintain balance
4th row	fighting with security
5th row	rc of male at vacant house

Common Values

Value	Count	Frequency (%)
cell phone	4819	1.2%
stop sign	4721	1.2%
speeding	4497	1.1%
SPEED	4155	1.0%
encroachment	3658	0.9%
radio call	3482	0.9%
speed	3479	0.9%
STOP SIGN	2446	0.6%
CELL PHONE	2071	0.5%
ped stop	2056	0.5%
Other values (183573)	372218	91.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
in	54094	2.7%
subject	51302	2.6%
of	50374	2.6%
on	43020	2.2%
a	40364	2.1%
was	37897	1.9%
to	35570	1.8%
stop	35343	1.8%
call	29540	1.5%
and	27506	1.4%
Other values (28030)	1562251	79.4%

Most occurring characters

Value	Count	Frequency (%)
	1563291	13.4%
e	750025	6.4%
i	566936	4.9%
t	537857	4.6%
a	530621	4.6%
n	527560	4.5%
o	497686	4.3%
s	430617	3.7%
r	398458	3.4%
l	366458	3.2%
Other values (82)	5459429	46.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6810897	58.6%
Uppercase Letter	2968066	25.5%
Space Separator	1563291	13.4%
Decimal Number	177838	1.5%
Other Punctuation	96107	0.8%
Dash Punctuation	6337	0.1%
Open Punctuation	3051	< 0.1%
Close Punctuation	3006	< 0.1%
Math Symbol	273	< 0.1%
Currency Symbol	62	< 0.1%
Other values (2)	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	750025	11.0%
i	566936	8.3%
t	537857	7.9%
a	530621	7.8%
n	527560	7.7%
o	497686	7.3%
s	430617	6.3%
r	398458	5.9%
l	366458	5.4%
d	296457	4.4%
Other values (16)	1908222	28.0%

Uppercase Letter

Value	Count	Frequency (%)
E	317034	10.7%
I	242750	8.2%
N	222256	7.5%
T	221118	7.4%
S	214555	7.2%
A	214253	7.2%
O	211596	7.1%
R	174216	5.9%
L	159276	5.4%
D	140110	4.7%
Other values (16)	850902	28.7%

Other Punctuation

Value	Count	Frequency (%)
.	63525	66.1%
,	17132	17.8%
/	10546	11.0%
'	2515	2.6%
&	907	0.9%
"	635	0.7%
;	263	0.3%
#	170	0.2%
:	156	0.2%
@	89	0.1%
Other values (5)	169	0.2%

Decimal Number

Value	Count	Frequency (%)
5	43365	24.4%
1	38792	21.8%
0	30811	17.3%
4	19052	10.7%
2	14599	8.2%
6	9982	5.6%
3	6180	3.5%
7	5266	3.0%
8	5078	2.9%
9	4713	2.7%

Math Symbol

Value	Count	Frequency (%)
+	211	77.3%
>	42	15.4%
=	10	3.7%
<	8	2.9%
~	2	0.7%

Open Punctuation

Value	Count	Frequency (%)
(	3004	98.5%
[	47	1.5%

Close Punctuation

Value	Count	Frequency (%)
)	2983	99.2%
]	23	0.8%

Modifier Symbol

Value	Count	Frequency (%)
`	4	80.0%
^	1	20.0%

Space Separator

Value	Count	Frequency (%)
	1563291	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	6337	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	62	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	5	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9778963	84.1%
Common	1849975	15.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	750025	7.7%
i	566936	5.8%
t	537857	5.5%
a	530621	5.4%
n	527560	5.4%
o	497686	5.1%
s	430617	4.4%
r	398458	4.1%
l	366458	3.7%
E	317034	3.2%
Other values (42)	4855711	49.7%

Common

Value	Count	Frequency (%)
	1563291	84.5%
.	63525	3.4%
5	43365	2.3%
1	38792	2.1%
0	30811	1.7%
4	19052	1.0%
,	17132	0.9%
2	14599	0.8%
/	10546	0.6%
6	9982	0.5%
Other values (30)	38880	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11628938	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1563291	13.4%
e	750025	6.4%
i	566936	4.9%
t	537857	4.6%
a	530621	4.6%
n	527560	4.5%
o	497686	4.3%
s	430617	3.7%
r	398458	3.4%
l	366458	3.2%
Other values (82)	5459429	46.9%

search_basis
Categorical

HIGH CARDINALITY
MISSING

Distinct	721
Distinct (%)	0.8%
Missing	321160
Missing (%)	78.8%
Memory size	3.1 MiB

Incident to arrest	39048
Condition of parole / probation/ PRCS / mandatory supervision	23248
Consent given	5589
Officer Safety/safety of others	3961
Vehicle inventory	1963
Other values (716)	12715

Length

Max length	182
Median length	174
Mean length	34.48750636
Min length	13

Characters and Unicode

Total characters	2983997
Distinct characters	34
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	396 ?
Unique (%)	0.5%

Sample

1st row	Vehicle inventory
2nd row	Incident to arrest
3rd row	Incident to arrest
4th row	Incident to arrest
5th row	Incident to arrest

Common Values

Value	Count	Frequency (%)
Incident to arrest	39048	9.6%
Condition of parole / probation/ PRCS / mandatory supervision	23248	5.7%
Consent given	5589	1.4%
Officer Safety/safety of others	3961	1.0%
Vehicle inventory	1963	0.5%
Condition of parole / probation/ PRCS / mandatory supervision\|Incident to arrest	1034	0.3%
Visible contraband	938	0.2%
Incident to arrest\|Officer Safety/safety of others	911	0.2%
Incident to arrest\|Condition of parole / probation/ PRCS / mandatory supervision	715	0.2%
Consent given\|Incident to arrest	564	0.1%
Other values (711)	8553	2.1%
(Missing)	321160	78.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	53566	12.3%
to	45600	10.5%
arrest	42100	9.7%
incident	42093	9.7%
of	36452	8.4%
probation	26783	6.2%
prcs	26783	6.2%
mandatory	26783	6.2%
parole	26783	6.2%
condition	25187	5.8%
Other values (128)	83147	19.1%

Most occurring characters

Value	Count	Frequency (%)
	348753	11.7%
o	294376	9.9%
n	268287	9.0%
t	257125	8.6%
r	222991	7.5%
e	214760	7.2%
i	209486	7.0%
a	176466	5.9%
s	129107	4.3%
d	105784	3.5%
Other values (24)	756862	25.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2321650	77.8%
Space Separator	348753	11.7%
Uppercase Letter	213531	7.2%
Other Punctuation	88097	3.0%
Math Symbol	11966	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	294376	12.7%
n	268287	11.6%
t	257125	11.1%
r	222991	9.6%
e	214760	9.3%
i	209486	9.0%
a	176466	7.6%
s	129107	5.6%
d	105784	4.6%
p	83631	3.6%
Other values (12)	359637	15.5%

Uppercase Letter

Value	Count	Frequency (%)
C	62715	29.4%
I	45600	21.4%
S	36333	17.0%
R	26783	12.5%
P	26783	12.5%
O	8261	3.9%
V	4990	2.3%
E	1652	0.8%
W	414	0.2%

Space Separator

Value	Count	Frequency (%)
	348753	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	88097	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	11966	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2535181	85.0%
Common	448816	15.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	294376	11.6%
n	268287	10.6%
t	257125	10.1%
r	222991	8.8%
e	214760	8.5%
i	209486	8.3%
a	176466	7.0%
s	129107	5.1%
d	105784	4.2%
p	83631	3.3%
Other values (21)	573168	22.6%

Common

Value	Count	Frequency (%)
	348753	77.7%
/	88097	19.6%
\|	11966	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2983997	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	348753	11.7%
o	294376	9.9%
n	268287	9.0%
t	257125	8.6%
r	222991	7.5%
e	214760	7.2%
i	209486	7.0%
a	176466	5.9%
s	129107	4.3%
d	105784	3.5%
Other values (24)	756862	25.4%

search_basis_exp
Categorical

HIGH CARDINALITY
MISSING

Distinct	28990
Distinct (%)	45.7%
Missing	344258
Missing (%)	84.4%
Memory size	3.1 MiB

incident to arrest	2366
search incident to arrest	1541
arrest	1321
arrested	800
Incident to arrest	772
Other values (28985)	56626

Length

Max length	250
Median length	236
Mean length	27.76601078
Min length	3

Characters and Unicode

Total characters	1761087
Distinct characters	88
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24904 ?
Unique (%)	39.3%

Sample

1st row	IMPOUNDED
2nd row	search incident to arrest
3rd row	search incident to arrest
4th row	Male drunk in public
5th row	273.6 viloation of TRO

Common Values

Value	Count	Frequency (%)
incident to arrest	2366	0.6%
search incident to arrest	1541	0.4%
arrest	1321	0.3%
arrested	800	0.2%
Incident to arrest	772	0.2%
INCIDENT TO ARREST	652	0.2%
searched incident to arrest	572	0.1%
consent	550	0.1%
5150 hold	516	0.1%
consent search	465	0.1%
Other values (28980)	53871	13.2%
(Missing)	344258	84.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
to	20323	7.0%
arrest	20146	7.0%
for	13693	4.7%
incident	12131	4.2%
search	9435	3.3%
arrested	9119	3.2%
subject	8539	3.0%
was	8139	2.8%
searched	6252	2.2%
and	5808	2.0%
Other values (7320)	175627	60.7%

Most occurring characters

Value	Count	Frequency (%)
	226198	12.8%
e	138232	7.8%
r	116668	6.6%
t	104510	5.9%
a	100275	5.7%
n	85671	4.9%
s	78939	4.5%
o	76673	4.4%
i	63628	3.6%
c	59719	3.4%
Other values (78)	710574	40.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1099455	62.4%
Uppercase Letter	359554	20.4%
Space Separator	226198	12.8%
Decimal Number	54950	3.1%
Other Punctuation	14716	0.8%
Close Punctuation	2745	0.2%
Open Punctuation	2743	0.2%
Dash Punctuation	699	< 0.1%
Math Symbol	14	< 0.1%
Currency Symbol	10	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	138232	12.6%
r	116668	10.6%
t	104510	9.5%
a	100275	9.1%
n	85671	7.8%
s	78939	7.2%
o	76673	7.0%
i	63628	5.8%
c	59719	5.4%
d	58870	5.4%
Other values (16)	216270	19.7%

Uppercase Letter

Value	Count	Frequency (%)
E	39943	11.1%
R	33124	9.2%
A	32432	9.0%
T	31278	8.7%
S	30653	8.5%
N	26150	7.3%
O	23930	6.7%
I	22840	6.4%
C	20263	5.6%
D	19228	5.3%
Other values (16)	79713	22.2%

Other Punctuation

Value	Count	Frequency (%)
.	9951	67.6%
,	2588	17.6%
/	1104	7.5%
&	597	4.1%
'	293	2.0%
:	62	0.4%
;	53	0.4%
"	40	0.3%
#	15	0.1%
?	4	< 0.1%
Other values (4)	9	0.1%

Decimal Number

Value	Count	Frequency (%)
5	14267	26.0%
1	12107	22.0%
0	8044	14.6%
4	5518	10.0%
2	4591	8.4%
6	3142	5.7%
7	2588	4.7%
3	2167	3.9%
9	1394	2.5%
8	1132	2.1%

Math Symbol

Value	Count	Frequency (%)
+	6	42.9%
=	5	35.7%
>	2	14.3%
<	1	7.1%

Close Punctuation

Value	Count	Frequency (%)
)	2744	> 99.9%
]	1	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	2	66.7%
`	1	33.3%

Space Separator

Value	Count	Frequency (%)
	226198	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2743	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	699	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	10	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1459009	82.8%
Common	302078	17.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	138232	9.5%
r	116668	8.0%
t	104510	7.2%
a	100275	6.9%
n	85671	5.9%
s	78939	5.4%
o	76673	5.3%
i	63628	4.4%
c	59719	4.1%
d	58870	4.0%
Other values (42)	575824	39.5%

Common

Value	Count	Frequency (%)
	226198	74.9%
5	14267	4.7%
1	12107	4.0%
.	9951	3.3%
0	8044	2.7%
4	5518	1.8%
2	4591	1.5%
6	3142	1.0%
)	2744	0.9%
(	2743	0.9%
Other values (26)	12773	4.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1761087	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	226198	12.8%
e	138232	7.8%
r	116668	6.6%
t	104510	5.9%
a	100275	5.7%
n	85671	4.9%
s	78939	4.5%
o	76673	4.4%
i	63628	3.6%
c	59719	3.4%
Other values (78)	710574	40.3%

seiz_basis
Categorical

HIGH CORRELATION
MISSING

Distinct	49
Distinct (%)	0.5%
Missing	398568
Missing (%)	97.8%
Memory size	3.1 MiB

Evidence	2999
Contraband	2090
Impound of vehicle	1217
Contraband\|Evidence	1049
Evidence\|Contraband	551
Other values (44)	1210

Length

Max length	76
Median length	65
Mean length	15.30759105
Min length	8

Characters and Unicode

Total characters	139544
Distinct characters	30
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.1%

Sample

1st row	Contraband
2nd row	Evidence\|Impound of vehicle
3rd row	Contraband\|Evidence
4th row	Impound of vehicle
5th row	Evidence

Common Values

Value	Count	Frequency (%)
Evidence	2999	0.7%
Contraband	2090	0.5%
Impound of vehicle	1217	0.3%
Contraband\|Evidence	1049	0.3%
Evidence\|Contraband	551	0.1%
Safekeeping as allowed by law/statute	387	0.1%
Evidence\|Impound of vehicle	237	0.1%
Contraband\|Evidence\|Impound of vehicle	106	< 0.1%
Abandoned property	76	< 0.1%
Contraband\|Impound of vehicle	57	< 0.1%
Other values (39)	347	0.1%
(Missing)	398568	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
evidence	2999	19.9%
contraband	2090	13.9%
of	1787	11.9%
vehicle	1662	11.0%
impound	1307	8.7%
contraband\|evidence	1049	7.0%
as	562	3.7%
allowed	562	3.7%
by	562	3.7%
evidence\|contraband	551	3.7%
Other values (38)	1913	12.7%

Most occurring characters

Value	Count	Frequency (%)
e	17040	12.2%
n	15843	11.4%
d	11812	8.5%
a	10977	7.9%
o	8379	6.0%
i	7575	5.4%
c	7013	5.0%
v	7011	5.0%
	5928	4.2%
t	5823	4.2%
Other values (20)	42143	30.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	118754	85.1%
Uppercase Letter	11708	8.4%
Space Separator	5928	4.2%
Math Symbol	2592	1.9%
Other Punctuation	562	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	17040	14.3%
n	15843	13.3%
d	11812	9.9%
a	10977	9.2%
o	8379	7.1%
i	7575	6.4%
c	7013	5.9%
v	7011	5.9%
t	5823	4.9%
b	4697	4.0%
Other values (12)	22584	19.0%

Uppercase Letter

Value	Count	Frequency (%)
E	5224	44.6%
C	4031	34.4%
I	1786	15.3%
S	563	4.8%
A	104	0.9%

Space Separator

Value	Count	Frequency (%)
	5928	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	2592	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	562	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	130462	93.5%
Common	9082	6.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	17040	13.1%
n	15843	12.1%
d	11812	9.1%
a	10977	8.4%
o	8379	6.4%
i	7575	5.8%
c	7013	5.4%
v	7011	5.4%
t	5823	4.5%
E	5224	4.0%
Other values (17)	33765	25.9%

Common

Value	Count	Frequency (%)
	5928	65.3%
\|	2592	28.5%
/	562	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	139544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	17040	12.2%
n	15843	11.4%
d	11812	8.5%
a	10977	7.9%
o	8379	6.0%
i	7575	5.4%
c	7013	5.0%
v	7011	5.0%
	5928	4.2%
t	5823	4.2%
Other values (20)	42143	30.2%

prop_type
Categorical

HIGH CARDINALITY
MISSING

Distinct	490
Distinct (%)	5.4%
Missing	398568
Missing (%)	97.8%
Memory size	3.1 MiB

Drugs/narcotics	1551
Vehicle	1194
Drug Paraphernalia	1115
Drugs/narcotics\|Drug Paraphernalia	794
Other Contraband or evidence	586
Other values (485)	3876

Length

Max length	202
Median length	151
Mean length	27.32305836
Min length	5

Characters and Unicode

Total characters	249077
Distinct characters	35
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	259 ?
Unique (%)	2.8%

Sample

1st row	Drugs/narcotics
2nd row	Alcohol
3rd row	Drugs/narcotics\|Money\|Drug Paraphernalia
4th row	Vehicle
5th row	Firearm(s)\|Ammunition\|Cell phone(s) or electronic device(s)

Common Values

Value	Count	Frequency (%)
Drugs/narcotics	1551	0.4%
Vehicle	1194	0.3%
Drug Paraphernalia	1115	0.3%
Drugs/narcotics\|Drug Paraphernalia	794	0.2%
Other Contraband or evidence	586	0.1%
Weapon(s) other than a firearm	509	0.1%
Alcohol	483	0.1%
Drug Paraphernalia\|Drugs/narcotics	236	0.1%
Cell phone(s) or electronic device(s)	201	< 0.1%
Suspected Stolen property	176	< 0.1%
Other values (480)	2271	0.6%
(Missing)	398568	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
paraphernalia	2089	8.8%
or	2046	8.6%
drug	1570	6.6%
drugs/narcotics	1551	6.5%
other	1518	6.4%
vehicle	1194	5.0%
contraband	1171	4.9%
drugs/narcotics\|drug	1057	4.4%
evidence	1054	4.4%
a	876	3.7%
Other values (233)	9672	40.6%

Most occurring characters

Value	Count	Frequency (%)
r	26702	10.7%
a	22214	8.9%
e	22150	8.9%
n	15726	6.3%
	14682	5.9%
c	14101	5.7%
o	13723	5.5%
i	13625	5.5%
s	11269	4.5%
t	10895	4.4%
Other values (25)	83990	33.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	200742	80.6%
Uppercase Letter	18711	7.5%
Space Separator	14682	5.9%
Math Symbol	4834	1.9%
Other Punctuation	3760	1.5%
Close Punctuation	3174	1.3%
Open Punctuation	3174	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	26702	13.3%
a	22214	11.1%
e	22150	11.0%
n	15726	7.8%
c	14101	7.0%
o	13723	6.8%
i	13625	6.8%
s	11269	5.6%
t	10895	5.4%
h	9023	4.5%
Other values (10)	41314	20.6%

Uppercase Letter

Value	Count	Frequency (%)
D	6775	36.2%
P	3015	16.1%
C	2046	10.9%
V	1623	8.7%
O	1171	6.3%
S	1150	6.1%
A	1028	5.5%
W	876	4.7%
F	548	2.9%
M	479	2.6%

Space Separator

Value	Count	Frequency (%)
	14682	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	4834	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	3760	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3174	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3174	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	219453	88.1%
Common	29624	11.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	26702	12.2%
a	22214	10.1%
e	22150	10.1%
n	15726	7.2%
c	14101	6.4%
o	13723	6.3%
i	13625	6.2%
s	11269	5.1%
t	10895	5.0%
h	9023	4.1%
Other values (20)	60025	27.4%

Common

Value	Count	Frequency (%)
	14682	49.6%
\|	4834	16.3%
/	3760	12.7%
)	3174	10.7%
(	3174	10.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	249077	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	26702	10.7%
a	22214	8.9%
e	22150	8.9%
n	15726	6.3%
	14682	5.9%
c	14101	5.7%
o	13723	5.5%
i	13625	5.5%
s	11269	4.5%
t	10895	4.4%
Other values (25)	83990	33.7%

cont
Categorical

HIGH CARDINALITY

Distinct	669
Distinct (%)	0.2%
Missing	5
Missing (%)	< 0.1%
Memory size	3.1 MiB

None	369726
Alcohol	11476
Drugs/narcotics	6526
Drug Paraphernalia	4943
Drugs/narcotics\|Drug Paraphernalia	2538
Other values (664)	12470

Length

Max length	194
Median length	4
Mean length	5.624027728
Min length	4

Characters and Unicode

Total characters	2292798
Distinct characters	35
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	322 ?
Unique (%)	0.1%

Sample

1st row	None
2nd row	None
3rd row	None
4th row	None
5th row	None

Common Values

Value	Count	Frequency (%)
None	369726	90.7%
Alcohol	11476	2.8%
Drugs/narcotics	6526	1.6%
Drug Paraphernalia	4943	1.2%
Drugs/narcotics\|Drug Paraphernalia	2538	0.6%
Weapon(s) other than a firearm	2222	0.5%
Other Contraband or evidence	2068	0.5%
Drug Paraphernalia\|Drugs/narcotics	947	0.2%
Suspected Stolen property	731	0.2%
Firearm(s)	665	0.2%
Other values (659)	5837	1.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	369726	81.8%
alcohol	11476	2.5%
paraphernalia	8064	1.8%
drugs/narcotics	6526	1.4%
drug	6396	1.4%
other	5435	1.2%
or	5160	1.1%
than	3255	0.7%
a	3255	0.7%
contraband	3241	0.7%
Other values (301)	29237	6.5%

Most occurring characters

Value	Count	Frequency (%)
o	431619	18.8%
e	424236	18.5%
n	418639	18.3%
N	369726	16.1%
r	86923	3.8%
a	75823	3.3%
c	48344	2.1%
	44092	1.9%
l	42132	1.8%
i	37630	1.6%
Other values (25)	313634	13.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1771285	77.3%
Uppercase Letter	434995	19.0%
Space Separator	44092	1.9%
Other Punctuation	12790	0.6%
Math Symbol	12012	0.5%
Open Punctuation	8812	0.4%
Close Punctuation	8812	0.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	431619	24.4%
e	424236	24.0%
n	418639	23.6%
r	86923	4.9%
a	75823	4.3%
c	48344	2.7%
l	42132	2.4%
i	37630	2.1%
s	36002	2.0%
h	34279	1.9%
Other values (10)	135658	7.7%

Uppercase Letter

Value	Count	Frequency (%)
N	369726	85.0%
D	23243	5.3%
A	13323	3.1%
P	10453	2.4%
C	5160	1.2%
W	3255	0.7%
O	3241	0.7%
S	3220	0.7%
F	1719	0.4%
M	1655	0.4%

Space Separator

Value	Count	Frequency (%)
	44092	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	12790	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	12012	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	8812	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	8812	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2206280	96.2%
Common	86518	3.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	431619	19.6%
e	424236	19.2%
n	418639	19.0%
N	369726	16.8%
r	86923	3.9%
a	75823	3.4%
c	48344	2.2%
l	42132	1.9%
i	37630	1.7%
s	36002	1.6%
Other values (20)	235206	10.7%

Common

Value	Count	Frequency (%)
	44092	51.0%
/	12790	14.8%
\|	12012	13.9%
(	8812	10.2%
)	8812	10.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2292798	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	431619	18.8%
e	424236	18.5%
n	418639	18.3%
N	369726	16.1%
r	86923	3.8%
a	75823	3.3%
c	48344	2.1%
	44092	1.9%
l	42132	1.8%
i	37630	1.6%
Other values (25)	313634	13.7%

actions
Categorical

HIGH CARDINALITY

Distinct	11672
Distinct (%)	2.9%
Missing	5
Missing (%)	< 0.1%
Memory size	3.1 MiB

None	246838
Curbside detention	24321
Handcuffed or flex cuffed	16308
Search of person was conducted\|Handcuffed or flex cuffed	9208
Handcuffed or flex cuffed\|Search of person was conducted	9022
Other values (11667)	101982

Length

Max length	360
Median length	4
Mean length	28.12013619
Min length	4

Characters and Unicode

Total characters	11463989
Distinct characters	38
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8059 ?
Unique (%)	2.0%

Sample

1st row	Search of property was conducted\|Vehicle impounded
2nd row	Curbside detention
3rd row	Patrol car detention\|Handcuffed or flex cuffed\|Search of person was conducted
4th row	Curbside detention\|Handcuffed or flex cuffed\|Search of person was conducted
5th row	None

Common Values

Value	Count	Frequency (%)
None	246838	60.5%
Curbside detention	24321	6.0%
Handcuffed or flex cuffed	16308	4.0%
Search of person was conducted\|Handcuffed or flex cuffed	9208	2.3%
Handcuffed or flex cuffed\|Search of person was conducted	9022	2.2%
Patrol car detention\|Handcuffed or flex cuffed	3113	0.8%
Curbside detention\|Handcuffed or flex cuffed	2976	0.7%
Patrol car detention\|Search of person was conducted\|Handcuffed or flex cuffed	2743	0.7%
Person photographed	2531	0.6%
Search of person was conducted\|Handcuffed or flex cuffed\|Search of property was conducted	2520	0.6%
Other values (11662)	88099	21.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
none	246838	15.5%
was	125241	7.8%
or	117174	7.3%
of	116125	7.3%
flex	111013	6.9%
person	90179	5.6%
cuffed	51222	3.2%
conducted	47480	3.0%
search	45074	2.8%
handcuffed	44529	2.8%
Other values (233)	602459	37.7%

Most occurring characters

Value	Count	Frequency (%)
e	1462183	12.8%
	1189655	10.4%
o	1051750	9.2%
n	837630	7.3%
d	819897	7.2%
r	725015	6.3%
f	707926	6.2%
c	705365	6.2%
t	485449	4.2%
a	474788	4.1%
Other values (28)	3004331	26.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	9391409	81.9%
Space Separator	1189655	10.4%
Uppercase Letter	648121	5.7%
Math Symbol	234804	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1462183	15.6%
o	1051750	11.2%
n	837630	8.9%
d	819897	8.7%
r	725015	7.7%
f	707926	7.5%
c	705365	7.5%
t	485449	5.2%
a	474788	5.1%
u	406584	4.3%
Other values (15)	1714822	18.3%

Uppercase Letter

Value	Count	Frequency (%)
N	246838	38.1%
S	116125	17.9%
H	111013	17.1%
P	81745	12.6%
C	58772	9.1%
A	16520	2.5%
V	10181	1.6%
F	6635	1.0%
E	190	< 0.1%
I	55	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1189655	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	234804	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10039530	87.6%
Common	1424459	12.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1462183	14.6%
o	1051750	10.5%
n	837630	8.3%
d	819897	8.2%
r	725015	7.2%
f	707926	7.1%
c	705365	7.0%
t	485449	4.8%
a	474788	4.7%
u	406584	4.0%
Other values (26)	2362943	23.5%

Common

Value	Count	Frequency (%)
	1189655	83.5%
\|	234804	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11463989	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	1462183	12.8%
	1189655	10.4%
o	1051750	9.2%
n	837630	7.3%
d	819897	7.2%
r	725015	6.3%
f	707926	6.2%
c	705365	6.2%
t	485449	4.2%
a	474788	4.1%
Other values (28)	3004331	26.2%

act_consent
Categorical

HIGH CARDINALITY
MISSING

Distinct	335
Distinct (%)	0.3%
Missing	297641
Missing (%)	73.0%
Memory size	3.1 MiB

NA\|NA	38272
NA\|NA\|NA	29881
NA\|NA\|NA\|NA	17701
NA\|NA\|NA\|NA\|NA	7547
NA\|NA\|NA\|NA\|NA\|NA	2403
Other values (330)	14239

Length

Max length	35
Median length	34
Mean length	8.251428987
Min length	1

Characters and Unicode

Total characters	908012
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	95 ?
Unique (%)	0.1%

Sample

1st row	NA\|NA
2nd row	NA\|NA\|NA
3rd row	NA\|NA\|NA
4th row	NA\|NA
5th row	NA\|NA\|NA

Common Values

Value	Count	Frequency (%)
NA\|NA	38272	9.4%
NA\|NA\|NA	29881	7.3%
NA\|NA\|NA\|NA	17701	4.3%
NA\|NA\|NA\|NA\|NA	7547	1.9%
NA\|NA\|NA\|NA\|NA\|NA	2403	0.6%
Y\|NA	1814	0.4%
NA\|Y	1112	0.3%
Y\|NA\|NA	1095	0.3%
NA\|Y\|NA	892	0.2%
NA\|NA\|NA\|NA\|NA\|NA\|NA	827	0.2%
Other values (325)	8499	2.1%
(Missing)	297641	73.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
na\|na	38272	34.8%
na\|na\|na	29881	27.2%
na\|na\|na\|na	17701	16.1%
na\|na\|na\|na\|na	7547	6.9%
na\|na\|na\|na\|na\|na	2403	2.2%
y\|na	1814	1.6%
na\|y	1112	1.0%
y\|na\|na	1095	1.0%
na\|y\|na	892	0.8%
na\|na\|na\|na\|na\|na\|na	827	0.8%
Other values (325)	8499	7.7%

Most occurring characters

Value	Count	Frequency (%)
N	330813	36.4%
A	328361	36.2%
\|	234804	25.9%
Y	14034	1.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	673208	74.1%
Math Symbol	234804	25.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	330813	49.1%
A	328361	48.8%
Y	14034	2.1%

Math Symbol

Value	Count	Frequency (%)
\|	234804	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	673208	74.1%
Common	234804	25.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	330813	49.1%
A	328361	48.8%
Y	14034	2.1%

Common

Value	Count	Frequency (%)
\|	234804	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	908012	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	330813	36.4%
A	328361	36.2%
\|	234804	25.9%
Y	14034	1.5%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	Unnamed: 0	stop_id	pid	id	ori	agency	exp_years	date	time	dur	is_serv	assign_key	assign_words	inters	block	ldmk	street	hw_exit	school_name	city	beat	beat_name	lim_eng	age	gender_words	gender_code	gendnc_code	lgbt	race	disability	reason_words	reasonid	reason_text	reason_detail	reason_exp	search_basis	search_basis_exp	seiz_basis	prop_type	cont	actions	act_consent
0	0	1	84362	1	84362_1	CA0371100	SD	10	2019-01-01	00:15:07	30	0	1	Patrol, traffic enforcement, field operations	NaN	3500.0	NaN	UNIVERSITY	NaN	NaN	SAN DIEGO	839	Cherokee Point 839	1	30	Male	1	NaN	No	hisp	None	Traffic Violation	54116.0	27150(A) VC - INADEQUATE MUFFLERS (I) 54116	Equipment Violation	LOUD EXHAUST	Vehicle inventory	IMPOUNDED	NaN	NaN	None	Search of property was conducted\|Vehicle impounded	NA\|NA
1	1	2	84364	1	84364_1	CA0371100	SD	2	2019-01-01	00:15:16	10	0	1	Patrol, traffic enforcement, field operations	NaN	7500.0	NaN	hillside dr	NaN	NaN	LA JOLLA	124	La Jolla 124	0	44	Female	2	NaN	No	white	None	Reasonable Suspicion	53130.0	415(2) PC - LOUD/UNREASONABLE NOISE (I) 53130	Officer witnessed commission of a crime	loud party	NaN	NaN	NaN	NaN	None	Curbside detention	NaN
2	2	3	84365	1	84365_1	CA0371100	SD	1	2019-01-01	00:02:00	5	0	1	Patrol, traffic enforcement, field operations	NaN	1300.0	NaN	ocean blvd	NaN	NaN	SAN DIEGO	122	Pacific Beach 122	0	30	Female	2	NaN	No	white	None	Reasonable Suspicion	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Officer witnessed commission of a crime	stumbling back and forth, unable to maintain balance	Incident to arrest	search incident to arrest	NaN	NaN	None	Patrol car detention\|Handcuffed or flex cuffed\|Search of person was conducted	NA\|NA\|NA
3	3	4	84366	1	84366_1	CA0371100	SD	1	2019-01-01	00:38:00	5	0	1	Patrol, traffic enforcement, field operations	NaN	800.0	NaN	garnet	NaN	NaN	SAN DIEGO	122	Pacific Beach 122	0	25	Male	1	NaN	No	hisp	None	Reasonable Suspicion	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Officer witnessed commission of a crime	fighting with security	Incident to arrest	search incident to arrest	NaN	NaN	None	Curbside detention\|Handcuffed or flex cuffed\|Search of person was conducted	NA\|NA\|NA
4	4	5	84369	1	84369_1	CA0371100	SD	17	2019-01-01	01:06:41	2	1	1	Patrol, traffic enforcement, field operations	NaN	4400.0	NaN	coronado	NaN	NaN	SAN DIEGO	614	Ocean Beach 614	1	40	Male	1	NaN	No	black	None	Reasonable Suspicion	32022.0	602 PC - TRESPASSING (M) 32022	Matched suspect description	rc of male at vacant house	NaN	NaN	NaN	NaN	None	None	NaN
5	5	6	84370	1	84370_1	CA0371100	SD	1	2019-01-01	01:11:05	5	0	1	Patrol, traffic enforcement, field operations	governor dr	NaN	NaN	radcliffe	NaN	NaN	SAN DIEGO	115	University City 115	0	75	Female	2	NaN	No	white	None	Traffic Violation	54110.0	24601 VC - FAIL MAINT LIC PLATE LAMP (I) 54110	Equipment Violation	no license plate lights	NaN	NaN	NaN	NaN	None	None	NaN
6	6	7	84371	1	84371_1	CA0371100	SD	1	2019-01-01	01:15:56	60	0	1	Patrol, traffic enforcement, field operations	la jolla village dr	NaN	NaN	villa la jolla dr	NaN	NaN	SAN DIEGO	126	Torrey Pines 126	0	45	Male	1	NaN	No	white	None	Traffic Violation	54056.0	20002 VC - HIT AND RUN (M) 54056	Moving Violation	drive hit victim vehicle causing damage and minor injury and fled on foot	NaN	NaN	NaN	NaN	None	None	NaN
7	7	8	84372	1	84372_1	CA0371100	SD	2	2019-01-01	01:10:54	10	0	1	Patrol, traffic enforcement, field operations	NaN	1000.0	NaN	pacific beach dr	NaN	NaN	SAN DIEGO	122	Pacific Beach 122	0	25	Male	1	NaN	No	hisp	None	Reasonable Suspicion	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Officer witnessed commission of a crime	fell in street	NaN	NaN	NaN	NaN	None	Curbside detention	NaN
8	8	9	84372	2	84372_2	CA0371100	SD	2	2019-01-01	01:10:54	10	0	1	Patrol, traffic enforcement, field operations	NaN	1000.0	NaN	pacific beach dr	NaN	NaN	SAN DIEGO	122	Pacific Beach 122	0	23	Female	2	NaN	No	hisp	None	Reasonable Suspicion	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Officer witnessed commission of a crime	fell in street	NaN	NaN	NaN	NaN	None	Curbside detention	NaN
9	9	10	84373	1	84373_1	CA0371100	SD	9	2019-01-01	01:10:52	5	0	1	Patrol, traffic enforcement, field operations	NaN	300.0	NaN	5th Av	NaN	NaN	SAN DIEGO	523	Gaslamp 523	0	21	Male	1	NaN	No	hisp	None	Reasonable Suspicion	64005.0	647(F) PC - DISORD CONDUCT:ALCOHOL (M) 64005	Officer witnessed commission of a crime	Male drunk in public unable to care for himself	Incident to arrest	Male drunk in public	NaN	NaN	None	Handcuffed or flex cuffed\|Search of person was conducted	NA\|NA

Last rows

	df_index	Unnamed: 0	stop_id	pid	id	ori	agency	exp_years	date	time	dur	assign_key	assign_words	inters	block	ldmk	street	hw_exit	school_name	city	beat	beat_name	age	gender_words	gender_code	gendnc_code	lgbt	race	disability	reason_words	reasonid	reason_text	reason_detail	reason_exp	search_basis	search_basis_exp	seiz_basis	prop_type	cont	actions	act_consent
407674	69804	69805	449687	3	449687_3	CA0371100	SD	1	2021-06-30	15:35:00	60	1	Patrol, traffic enforcement, field operations	NaN	100.0	NaN	W San Ysidro blvd	NaN	NaN	SAN YSIDRO	712	San Ysidro 712	60	Male	1	NaN	No	white	None	Traffic Violation	54431.0	24951(B) VC - TURN SIGNAL VIOLATION (I) 54431	Moving Violation	pulled over vehicle for not using turn signal for a lane change and for the 3rd brakelight being out.	NaN	NaN	NaN	NaN	None	Person removed from vehicle by order	NaN
407675	69805	69806	449692	1	449692_1	CA0371100	SD	1	2021-06-30	22:46:00	20	1	Patrol, traffic enforcement, field operations	NaN	4300.0	NaN	University	NaN	NaN	SAN DIEGO	832	Teralta West 832	18	Male	1	NaN	No	hisp	None	Traffic Violation	54168.0	5204(A) VC - EXPIRED TABS/FAIL DISPLAY (I) 54168	Non-moving Violation, including Registration Violation	displayed reg expired over 6 months	NaN	NaN	NaN	NaN	None	None	NaN
407676	69806	69807	449693	1	449693_1	CA0371100	SD	1	2021-06-30	15:00:00	30	1	Patrol, traffic enforcement, field operations	NaN	200.0	NaN	Via De San Ysidro	NaN	NaN	SAN YSIDRO	712	San Ysidro 712	30	Male	1	NaN	No	hisp	None	Traffic Violation	54649.0	24603(D) VC - STOPLAMPS:VEH 2 REQUIRED (I) 54649	Equipment Violation	Subject had a brakeligh that was out.	Condition of parole / probation/ PRCS / mandatory supervision	NaN	NaN	NaN	None	Person removed from vehicle by order\|Curbside detention\|Search of property was conducted\|Search of person was conducted	NA\|NA\|NA\|NA
407677	69807	69808	449693	2	449693_2	CA0371100	SD	1	2021-06-30	15:00:00	30	1	Patrol, traffic enforcement, field operations	NaN	200.0	NaN	Via De San Ysidro	NaN	NaN	SAN YSIDRO	712	San Ysidro 712	30	Female	2	NaN	No	hisp	None	Traffic Violation	54649.0	24603(D) VC - STOPLAMPS:VEH 2 REQUIRED (I) 54649	Equipment Violation	Subject had a brakelight that was out.	Condition of parole / probation/ PRCS / mandatory supervision	NaN	NaN	NaN	None	Search of property was conducted\|Person removed from vehicle by order	NA\|NA
407678	69808	69809	449694	1	449694_1	CA0371100	SD	1	2021-06-30	23:30:00	5	1	Patrol, traffic enforcement, field operations	NaN	5600.0	NaN	ECB	NaN	NaN	SAN DIEGO	821	Rolando 821	25	Male	1	NaN	No	white	None	Traffic Violation	54168.0	5204(A) VC - EXPIRED TABS/FAIL DISPLAY (I) 54168	Non-moving Violation, including Registration Violation	expired reg over 6 months	NaN	NaN	NaN	NaN	None	None	NaN
407679	69809	69810	449701	1	449701_1	CA0371100	SD	1	2021-06-30	21:36:15	5	1	Patrol, traffic enforcement, field operations	NaN	500.0	NaN	Saturn	NaN	NaN	SAN DIEGO	721	Egger Highlands 721	50	Male	1	NaN	No	black	None	Reasonable Suspicion	53130.0	415(2) PC - LOUD/UNREASONABLE NOISE (I) 53130	Matched suspect description	Radio call of large group of people at a vehicle making loud noise.	NaN	NaN	NaN	NaN	None	Curbside detention	NaN
407680	69810	69811	449709	1	449709_1	CA0371100	SD	5	2021-06-30	23:29:46	10	1	Patrol, traffic enforcement, field operations	NaN	300.0	NaN	17th st	NaN	NaN	SAN DIEGO	521	East Village 521	40	Male	1	NaN	No	white	None	Traffic Violation	54427.0	21800(D) VC - FAIL STOP/YIELD:INOP SIGN (I) 54427	Moving Violation	didnt stop at stop sign	NaN	NaN	NaN	NaN	None	None	NaN
407681	69811	69812	449716	1	449716_1	CA0371100	SD	1	2021-06-30	23:45:00	20	1	Patrol, traffic enforcement, field operations	NaN	4200.0	NaN	del sol ct	NaN	NaN	SAN DIEGO	723	Otay Mesa West 723	30	Male	1	NaN	No	hisp	None	Reasonable Suspicion	99999.0	NA - XX AA - CODE NOT FOUND IN TABLE (X) 99999	Matched suspect description	415 - subj and later found to be in uncles driveway	NaN	NaN	NaN	NaN	None	Person removed from vehicle by order	NaN
407682	69812	69813	449726	1	449726_1	CA0371100	SD	11	2021-06-30	15:54:00	12	1	Patrol, traffic enforcement, field operations	15 SOUTH / AERO DRIVE	NaN	NaN	NaN	NaN	NaN	SAN DIEGO	313	Kearney Mesa 313	40	Female	2	NaN	No	hisp	None	Traffic Violation	54566.0	23123(A) VC - USE CELLPH W/DRIV W/O HFD (I) 54566	Moving Violation	CELL PHONE	NaN	NaN	NaN	NaN	None	None	NaN
407683	69813	69814	449933	1	449933_1	CA0371100	SD	1	2021-06-30	17:45:00	120	1	Patrol, traffic enforcement, field operations	NaN	4200.0	NaN	mISSION BLVD	NaN	NaN	SAN DIEGO	122	Pacific Beach 122	30	Male	1	NaN	No	hisp	None	Reasonable Suspicion	13219.0	245(A)(1) PC - ADW NOT FIREARM (F) 13219	Matched suspect description	RADIO CALL REGARDING A MALE HITTING ANOTHER MALE WITH A CROWBAR	Incident to arrest	245PC	NaN	NaN	None	Handcuffed or flex cuffed\|Search of person was conducted\|Curbside detention\|Patrol car detention	NA\|NA\|NA\|NA

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script